US and Worldwide: +1 (866) 660-7555

Search Forums:

Type: Posts; User: mcampbell; Keyword(s):

Page 1 of 16 1 2 3 4

Search Forums: Search took 0.21 seconds.

  1. Replies
    5
    Views
    338

    The '*' crossjoin operator isn't supported for...

    The '*' crossjoin operator isn't supported for native evaluation in the released Mondrian builds. Converting the set below to use NonEmptyCrossJoin should have much better performance.
    ...
  2. Do you see a stack trace anywhere in your logs...

    Do you see a stack trace anywhere in your logs that originates in Mondrian? The stack trace you posted is from the servlet.

    The query VisualTotals query you have above runs for me without error...
  3. Replies
    5
    Views
    338

    Can you post the MDX?

    Can you post the MDX?
  4. The "All" member of a hierarchy rolls up the...

    The "All" member of a hierarchy rolls up the values of all children, not just those that happen to be projected on an axis. To get the total value of a set of members use the Aggregate() function,...
  5. Replies
    2
    Views
    265

    What I recommend to most people is to start with...

    What I recommend to most people is to start with an installation of Pentaho biserver or the Saiku server, both of which use Mondrian. This can let you try out Mondrian, create schemas, run queries,...
  6. Replies
    20
    Views
    1,074

    [COLOR=#333333] You can import your schema using...

    [COLOR=#333333]
    You can import your schema using Data Source Manager in the user console. Alternatively you can open it in Pentaho Schema Workbench and publish from there.



    Not sure what you...
  7. If you're using Mondrian 3 see this reference: ...

    If you're using Mondrian 3 see this reference: http://mondrian.pentaho.com/documentation/aggregate_tables.php

    If you're using Mondrian 4, look at the sample Foodmart schema for how aggregate...
  8. Replies
    2
    Views
    326

    If you specify your format_string in a...

    If you specify your format_string in a CalculatedMemberProperty you can use an MDX expression to determine how the value will be displayed. Something like

    <CalculatedMemberProperty...
  9. Replies
    20
    Views
    1,074

    If you've specified an ordinalColumn then there's...

    If you've specified an ordinalColumn then there's often no reason to use an ORDER function to specify that ordering. ordinalColumn defines the natural ordering of that level.

    If you need to do a...
  10. Replies
    20
    Views
    1,074

    I meant add an ordinalColumn to your . ...

    I meant add an ordinalColumn to your <Level>.

    http://mondrian.pentaho.com/documentation/schema.php#Level_Order_and_Display
  11. Replies
    20
    Views
    1,074

    The member_key for the CalendarYearMonth level is...

    The member_key for the CalendarYearMonth level is the CalendarYearMonth column-- which results in the alpha sort you're getting. Looks like you also have a CalendarYearMonthNum column--which I'm...
  12. Replies
    20
    Views
    1,074

    The first argument of the MDX ORDER function...

    The first argument of the MDX ORDER function isn't really "the first sort operation"-- it's just the set of tuples to sort. That sort will happen within hierarchical boundaries (unless you use the...
  13. Replies
    5
    Views
    378

    Thanks for posting, rita_gwen. That stack trace...

    Thanks for posting, rita_gwen. That stack trace looks to be entirely from saiku, however. Do you see any other logged errors that have any mondrian classes referenced in the stack trace?
  14. Replies
    20
    Views
    1,074

    I had gotten the impression that he was using a...

    I had gotten the impression that he was using a different column for his key. The dimension definition should clarify.

    If the desire here is really just to have the months sorted, using a numeric...
  15. Replies
    20
    Views
    1,074

    Oh sorry- I meant the mondrian schema dimension...

    Oh sorry- I meant the mondrian schema dimension definition xml, not the table definition.

    One thing you can also try to shed some light on this is to run a query that tells you what MEMBER_KEY...
  16. Replies
    1
    Views
    218

    Sure. Something like select...

    Sure. Something like

    select filter(Customer.customer.members, Customer.properties('industry') = 'banking') on 0 from myCube
  17. Replies
    20
    Views
    1,074

    Can you post the schema definition of your...

    Can you post the schema definition of your DimTime dimension?
  18. Replies
    5
    Views
    378

    It does sound like you might have found a bug. ...

    It does sound like you might have found a bug.

    Can you post the complete stack trace from the failure? Thanks!
  19. Which version are you using? And are you using a...

    Which version are you using? And are you using a consistent version for workbench and biserver?
  20. Replies
    20
    Views
    1,074

    Are you saying the Order function is not properly...

    Are you saying the Order function is not properly ordering based on the 2nd argument?

    And how are you accessing the member key? Something like Time.CurrentMember.Properties('MEMBER_KEY')?
  21. In biserver, click on the "Manage Data Sources",...

    In biserver, click on the "Manage Data Sources", then "New Data Source". That opens the wizard. Make sure to click the radio "Reporting and Analysis" so it will generate a cube schema as well.
  22. The NullPointer you're getting is inside of saiku...

    The NullPointer you're getting is inside of saiku code, so it would be good to ask on the saiku forum if you haven't already.

    Are there any other errors logged?
  23. Replies
    11
    Views
    1,102

    Can you implement this as a UserDefinedFunction? ...

    Can you implement this as a UserDefinedFunction? That'd allow you to plug in your function without hacking anything.
  24. Replies
    7
    Views
    18,608

    Hi Laura, Schema workbench is the main tool...

    Hi Laura,

    Schema workbench is the main tool used for defining schemas:
    http://help.pentaho.com/Documentation/6.0/0N0/020/070/020

    This link gives more details about schema construction:...
  25. No, Excel's not an option. An alternative to...

    No, Excel's not an option. An alternative to workbench is to use Pentaho's Data Source Wizard, which can auto-generate simple schemas.
  26. Replies
    11
    Views
    1,102

    Have you looked at the SQL/MDX debug logging...

    Have you looked at the SQL/MDX debug logging during execution? That may give you some idea of why the performance is so bad, and why it differs from 3.3.
  27. Replies
    2
    Views
    408

    1) Yes, you can have any number of aggregate...

    1) Yes, you can have any number of aggregate tables. The desire is to create aggregate tables which hit the majority of attribute rollups that will be requested by your workloads. So if you have...
  28. Replies
    3
    Views
    397

    The best place for Mondrian 4 doc is Julian's...

    The best place for Mondrian 4 doc is Julian's book: https://www.manning.com/books/mondrian-in-action

    Other than that, your best bet is to use the M4 Foodmart.xml schema as an example: ...
  29. Replies
    1
    Views
    266

    So you want a measure to be null for certain...

    So you want a measure to be null for certain members?

    You can define a calculated measure that uses a conditional. Something like

    iif( MyDimension.CurrentMember IS MyDimension.MyMember,...
  30. Replies
    1
    Views
    438

    This is probably a better question for the saiku...

    This is probably a better question for the saiku forum: https://groups.google.com/a/saiku.meteorite.bi/forum/#!forum/user
  31. There are some inconsistencies in what Mondrian's...

    There are some inconsistencies in what Mondrian's XMLA issues and what AdomdClient expects.

    http://jira.pentaho.com/browse/MONDRIAN-1836
  32. Replies
    1
    Views
    293

    Are you using a parent-child hierarchy? Sounds...

    Are you using a parent-child hierarchy? Sounds like not. P-C often fits nicely with Employee type dimensions, where each employee may manage some number of employees, and you need to do things like...
  33. The easiest way to test out calculated members is...

    The easiest way to test out calculated members is by running them in MDX queries, including a WITH block at the start of your query. E.g.

    WITH MEMBER measures.foo as...
  34. Replies
    1
    Views
    299

    CrossJoin(set1, set2) should be functionally...

    CrossJoin(set1, set2)

    should be functionally equivalent to

    set1 * set2

    If you have a case with SampleData that gives different results that could be a bug. Can you pass on repro steps?
    ...
  35. Replies
    4
    Views
    527

    The answer depends a lot on the MDX, schema and...

    The answer depends a lot on the MDX, schema and data.

    Typically when I'm looking to identify the cause of poor performance I start out by turning on MDX and SQL debug logging (in log4j.xml),...
  36. CurrentDateMember might be useful to you. Using...

    CurrentDateMember might be useful to you. Using that with the Tail function can give you the set of the last 30 days.
    Checkout out Diethard's blog post on it: ...
  37. Replies
    4
    Views
    527

    The distributed cache holds cell data (segments)....

    The distributed cache holds cell data (segments). Being able to pull segments out of the cache rather than executing SQL can reduce a good chunk of execution time, but other parts of MDX evaluation...
  38. Replies
    3
    Views
    397

    Your link points to incomplete documentation for...

    Your link points to incomplete documentation for Mondrian 4.

    Mondrian 3's schema documentation can be found here: http://mondrian.pentaho.com/documentation/
  39. You need to drop your jar in the classpath. ...

    You need to drop your jar in the classpath. biserver/tomcat/webapps/pentaho/WEB-INF/lib should work.
  40. Replies
    2
    Views
    308

    One option is to use a member formatter: ...

    One option is to use a member formatter: http://mondrian.pentaho.com/documentation/schema.php#Member_formatter

    Alternatively you could place the si/no values in a char field and reference that...
  41. It looks like you're crossjoining many single...

    It looks like you're crossjoining many single members. If each argument in a crossjoin is a single member or tuple then the result is a tuple set of size 1, which is more easily represented as just...
  42. Replies
    5
    Views
    2,303

    LookupCube() isn't implemented in Mondrian. ...

    LookupCube() isn't implemented in Mondrian.

    Most places where you might want to use lookupCube are better handled by bringing the cubes together in a virtualcube or measure group. (IIRC this is...
  43. Replies
    4
    Views
    383

    For your 1st option, I'd start out with a sanity...

    For your 1st option, I'd start out with a sanity check-- set your caption SQL expression to something like a fixed literal string value (say 'FOO'). That way you can confirm the caption expression...
  44. Replies
    4
    Views
    383

    There are a couple ways to control how a member...

    There are a couple ways to control how a member will be displayed:
    1) use a captionColumn defined on the level, pointed to a column with the desired caption to be associated with each member. ...
  45. Replies
    4
    Views
    640

    Is employeeStatus a degenerate dimension? I...

    Is employeeStatus a degenerate dimension? I wonder if it's trying to find a join path between your agg table and the fact table to handle degenerates.

    You could try setting employeeStatus to...
  46. Can you post the MDX and some of these multiple...

    Can you post the MDX and some of these multiple queries from your log file?
  47. Replies
    1
    Views
    298

    You might be best off asking on the saiku forum.

    You might be best off asking on the saiku forum.
  48. Looks like you're using integrated security. ...

    Looks like you're using integrated security. Does your user have permission on the database? Are you able to connect from other clients using that account?
  49. Replies
    3
    Views
    361

    Can you post your MDX? A compound slicer...

    Can you post your MDX?

    A compound slicer should effectively be the same as wrapping the set of members in an Aggregate(), giving the rolled up value of the set.
  50. There are a couple issues with your query- ...

    There are a couple issues with your query- Drillthrough should select a single cell from a cube. You have sets of members on COLUMNS and PAGES, so the DRILLTHROUGH is incorrectly being applied to...
Results 1 to 50 of 796
Page 1 of 16 1 2 3 4