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

Search Forums:

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

Page 1 of 15 1 2 3 4

Search Forums: Search took 0.11 seconds.

  1. Replies
    1
    Views
    52

    By aggregation, are you talking about the report...

    By aggregation, are you talking about the report totaling in Saiku? Last I checked, Saiku handled all report totaling itself, not pushing down to Mondrian. I'd ask on the Saiku forum.
  2. Replies
    2
    Views
    98

    If you want your level member to be backed by...

    If you want your level member to be backed by DOB, but displayed as Age, one option is to use a member formatter. http://mondrian.pentaho.com/documentation/schema.php#Member_formatter. Deithard...
  3. Also, would be worth looking at and posting the...

    Also, would be worth looking at and posting the "workbench log for full stacktrace".
  4. Replies
    4
    Views
    222

    Yes, I think your options are to place the...

    Yes, I think your options are to place the multiplied field directly on the table, or in a view.

    Not sure I understand your 3rd option. In you example you've got all fields present on the fact...
  5. Virtual cubes are the way to handle cross-fact...

    Virtual cubes are the way to handle cross-fact table analysis in Mondrian.
    http://mondrian.pentaho.com/documentation/schema.php#Virtual_cubes
  6. Latest stable is 3.10. Mondrian 4.x is...

    Latest stable is 3.10.

    Mondrian 4.x is dramatically different in lots of ways, and has been held back for general usage due to the challenge of user upgrade. It is currently used for EE support...
  7. Replies
    4
    Views
    190

    This is a good place to start: ...

    This is a good place to start: http://mondrian.pentaho.com/documentation/schema.php
  8. Replies
    4
    Views
    364

    Either Saiku needs to stop using the shortcut *...

    Either Saiku needs to stop using the shortcut * operator or Mondrian needs to add support for performance optimizations with it.

    Vote for MONDRIAN-2284.
  9. Hi ekinasm, Levels in a hierarchy are intended...

    Hi ekinasm,

    Levels in a hierarchy are intended to be a natural rollup. Classic example is Year/Qtr/Month/Day, or Country/State/City. Your D_PERSON hierarchy has a level structure that doesn't...
  10. Can't really help you with your network problem....

    Can't really help you with your network problem.

    For defining parameters that depends on your client. If you're using CDE you may want to take this to the CTools forum.
  11. Replies
    4
    Views
    222

    Microsoft's MDX has a high degree of overlap with...

    Microsoft's MDX has a high degree of overlap with Mondrian's, so a good place to learn about MDX and how to define calculated members and sets is just going through some of their docs (like...
  12. Mondrian represents that value with a Java...

    Mondrian represents that value with a Java double, which (iirc) has between 15-17 decimal digits. Needing a greater level of precision for a dimension member name is fairly unusual. One possible...
  13. That NullPointer is originating the the mysql...

    That NullPointer is originating the the mysql driver. I'm assuming you've double and triple checked your connection settings? And are able to connect with the same settings from other clients?
    ...
  14. Replies
    4
    Views
    233

    Saiku handles its own aggregation, rather than...

    Saiku handles its own aggregation, rather than pushing it into the MDX and letting Mondrian handle it.

    I'd take this question to the Saiku forum.
  15. Replies
    2
    Views
    215

    As an alternative, have you looked at using...

    As an alternative, have you looked at using CurrentDate()?

    http://diethardsteiner.blogspot.com/2009/10/current-date-function-on-mondrian.html
  16. Replies
    4
    Views
    233

    What's the MDX?

    What's the MDX?
  17. Try rewriting your MDX with Crossjoin() instead...

    Try rewriting your MDX with Crossjoin() instead of '*'. There are native tuple optimizations that are skipped if using the shortcut '*' operator.
  18. Replies
    2
    Views
    254

    It's a little hard to guess what's going on. If...

    It's a little hard to guess what's going on. If you're a pentaho customer you may want to submit a support request.

    If you'd prefer to keep it on the forum I'd be curious to see the analyzer...
  19. If you can give some more info someone on this...

    If you can give some more info someone on this thread might be able to help out. For example: the MDX that's slow, info about dimension cardinality, DEBUG level logs of a slow run, any non-default...
  20. Replies
    6
    Views
    388

    One useful thing to keep in mind with MDX engines...

    One useful thing to keep in mind with MDX engines is that a single member from each hierarchy will always be present in evaluation context (with a small caveat involving compound slicers). If the...
  21. Hi ss, Mondrian calculated members are defined...

    Hi ss,
    Mondrian calculated members are defined using MDX expressions. I'd recommend brushing up on some basics of MDX and playing around to see if you can get what you're looking for.

    Take a...
  22. MONDRIAN-1725 is related to the error you're...

    MONDRIAN-1725 is related to the error you're seeing. The problem is that ParallelPeriod is looking for a physical member at a parallel point in the tree. There is no parallel calculated member. ...
  23. In MDX the colon operator is used to define a...

    In MDX the colon operator is used to define a range of members. For example, to define members of the [Minutes] level between 5 and 10 you'd do something like:

    { [Call Duration].[Minutes].[5] :...
  24. Replies
    1
    Views
    169

    http://lists.pentaho.org/mailman/listinfo/mondrian...

    http://lists.pentaho.org/mailman/listinfo/mondrian


    Keep in mind that Mondrian mailing list is for dev discussions. General functionality questions are better handled in this forum (as well as...
  25. Do you mean just a concatenation of the date...

    Do you mean just a concatenation of the date string and time string? Your mention of epoch timestamp confused me- I think of that as using a single unit of measurement (like seconds) from a defined...
  26. The logs only span a second and don't include the...

    The logs only span a second and don't include the timeout error.

    Can you set the "mondrian" logger to DEBUG in log4j.xml and rerun your test?
  27. That is weird. Not sure what would cause that. ...

    That is weird. Not sure what would cause that.

    Can you attach your schema and logs?
  28. Can you attach your logs?

    Can you attach your logs?
  29. Replies
    1
    Views
    206

    There was a recent post about cumulative...

    There was a recent post about cumulative measures: http://forums.pentaho.com/showthread.php?187240-MDX-cumulative-measure

    HTH
  30. Not possible in Mondrian 3. It is possible in...

    Not possible in Mondrian 3.

    It is possible in Mondrian 4, but that's not directly supported in Pentaho yet (although newer versions of Saiku use it).

    Here's some more info and workarounds: ...
  31. Replies
    2
    Views
    251

    Often it makes sense to include geographic levels...

    Often it makes sense to include geographic levels in a Customer dimension, with [Customer Name] as the bottom level. That makes it easier to deal with cases like this, since your customer member...
  32. Replies
    4
    Views
    303

    That's odd. This query gives me -1: with...

    That's odd. This query gives me -1:

    with member measures.f as DateDiff('yyyy',cdate('Oct 12, 2014'),now()) select measures.f on 0 from sales;

    The string is parsed w/ java.text.DateFormat,...
  33. Replies
    4
    Views
    364

    Saiku in some cases uses the asterisk crossjoin...

    Saiku in some cases uses the asterisk crossjoin operator. That's functionally equivalent to a Crossjoin( set1, set2 ), but unfortunately side-steps native eval optimizations. MONDRIAN-2284 is...
  34. Thread: Jira 2296

    by mcampbell
    Replies
    1
    Views
    201

    Hi Matthew- Thanks for your contribution. There...

    Hi Matthew-
    Thanks for your contribution. There has been recent internal conversations of that bug and it looks like the case may be escalated in priority. Keep your eye on the jira case. If...
  35. Replies
    2
    Views
    388

    Are Ano and Semestre part of a time hierarchy? ...

    Are Ano and Semestre part of a time hierarchy? If so than something like:

    SUM( Semestre.Semestre.members.Item(0) : Semestre.CurrentMember, measures.[Cantidad personas])

    That grabs the first...
  36. Replies
    1
    Views
    226

    The members of the [Severity] level will include...

    The members of the [Severity] level will include each unique path down the hierarchy. Even though the [Type 1].[Severity 1] and [Type 2].[Severity 1] share the same name, they are treated as...
  37. Microsoft has some support I'd love to see in...

    Microsoft has some support I'd love to see in Mondrian for this sort of thing-- you can specify the aggregation to use for PC levels.

    In Mondrian, though, you might be able to a brute force...
  38. Anything interesting in the logs?

    Anything interesting in the logs?
  39. When queries involve large cellsets it's often...

    When queries involve large cellsets it's often necessary to bump up the cell batch size (see config). It also is worth considering your memory allocation, making sure to give Mondrian adequate...
  40. Replies
    3
    Views
    165

    You are right, there should be more and better...

    You are right, there should be more and better documentation on this. The idea here is just to include the jointly-applicable attributes in shared dims across the two cubes. This can mean splitting...
  41. For the All member name, by default Mondrian will...

    For the All member name, by default Mondrian will just take the hierarchy name and strap an s on the end. You can set that name to be anything you want, though: ...
  42. Replies
    3
    Views
    165

    What you propose is a reasonable way to go about...

    What you propose is a reasonable way to go about it, i.e. have a split [Year] out into a separate dimension and have that dim shared by both cubes. I've worked with some models that actually had...
  43. You're asking for all members of the [Provinces]...

    You're asking for all members of the [Provinces] level, which does not include the all member. You could try something like

    [Geography.Admin].members

    or

    { [Geography.Admin].[All...
  44. Replies
    4
    Views
    237

    Looking at that again, I think I was making it...

    Looking at that again, I think I was making it way too difficult. Try something like this.

    Aggregate( Tail(Descendants( Time.CurrentMember, Time.Month), 12), measures.[unit sales])
  45. Replies
    4
    Views
    237

    A little verbose, but something like this should...

    A little verbose, but something like this should work for you:

    Aggregate(
    ParallelPeriod( time.month, 12, Tail(Descendants( Time.CurrentMember, Time.Month), 1).Item(0)) :...
  46. Replies
    19
    Views
    518

    That's too bad. Hopefully they'll have a fix...

    That's too bad. Hopefully they'll have a fix soon. I tried out Pivot4J as well, and it also appears to handle totals itself rather than pushing that evaluation to Mondrian.

    I can recommend...
  47. Replies
    19
    Views
    518

    Did a quick scan of Saiku's code and it looks...

    Did a quick scan of Saiku's code and it looks like they're handling totalling internally. See...
  48. When you have multiple grains you want to start...

    When you have multiple grains you want to start thinking about multiple cubes--i.e. create a second cube based on School, including the [student count] measure. You can then bring that cube together...
  49. Replies
    2
    Views
    187

    You can publish from schema workbench. ...

    You can publish from schema workbench. Alternatively you can upload the XML via data source manager (create a new Analysis datasource).
  50. Replies
    19
    Views
    518

    Sorry for bringing up scope isolation before,...

    Sorry for bringing up scope isolation before, that was really more of an aside not intended for this case (but for those curious, it's controlled globally by a property...
Results 1 to 50 of 704
Page 1 of 15 1 2 3 4