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

Search Forums:

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

Page 1 of 14 1 2 3 4

Search Forums: Search took 0.12 seconds.

  1. 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...
  2. 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.
  3. Replies
    3
    Views
    76

    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...
  4. 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...
  5. 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?
    ...
  6. Replies
    4
    Views
    131

    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.
  7. Replies
    2
    Views
    131

    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
  8. Replies
    4
    Views
    131

    What's the MDX?

    What's the MDX?
  9. 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.
  10. Replies
    2
    Views
    181

    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...
  11. 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...
  12. Replies
    6
    Views
    303

    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...
  13. 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...
  14. 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. ...
  15. 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] :...
  16. Replies
    1
    Views
    151

    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...
  17. 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...
  18. 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?
  19. 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?
  20. Can you attach your logs?

    Can you attach your logs?
  21. Replies
    1
    Views
    179

    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
  22. 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: ...
  23. Replies
    2
    Views
    225

    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...
  24. Replies
    4
    Views
    265

    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,...
  25. Replies
    3
    Views
    218

    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...
  26. Thread: Jira 2296

    by mcampbell
    Replies
    1
    Views
    189

    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...
  27. Replies
    2
    Views
    309

    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...
  28. Replies
    1
    Views
    203

    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...
  29. 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...
  30. Anything interesting in the logs?

    Anything interesting in the logs?
  31. 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...
  32. Replies
    3
    Views
    161

    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...
  33. 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: ...
  34. Replies
    3
    Views
    161

    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...
  35. 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...
  36. Replies
    4
    Views
    220

    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])
  37. Replies
    4
    Views
    220

    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)) :...
  38. Replies
    19
    Views
    454

    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...
  39. Replies
    19
    Views
    454

    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...
  40. 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...
  41. Replies
    2
    Views
    177

    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).
  42. Replies
    19
    Views
    454

    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...
  43. I don't know, I haven't had much chance to play...

    I don't know, I haven't had much chance to play around w/ Excel+Mondrian. Defining calculations in the cube is certainly an option, but defeats the flexibility of creating calcs in Excel.

    I have...
  44. Replies
    19
    Views
    454

    SOLVE_ORDER is the key, but missing from this...

    SOLVE_ORDER is the key, but missing from this thread is what the solve order is of the calculated member that's doing the totaling. Solve order governs evaluation order when two calculations...
  45. Unfortunately Mondrian doesn't currently support...

    Unfortunately Mondrian doesn't currently support SESSION MEMBERs. Excel is trying to create one, causing the failure.
  46. That should be it.

    That should be it.
  47. Gotcha. I looked a little closer and found that...

    Gotcha. I looked a little closer and found that the InverseNormal function uses commons-math. That function may or may not work w/ the 3.0. If you're not using InverseNormal than you're probably...
  48. Do you mean Mondrian version 3.0? I wasn't aware...

    Do you mean Mondrian version 3.0? I wasn't aware there was any support for the wilcoxon test back then, and there isn't currently. commons-math also does not currently appear to be a dependency.
  49. Schema Workbench offers more flexibility in model...

    Schema Workbench offers more flexibility in model definition. Of course, most flexible is manual editing of the XML :). Regardless of how you're creating your schema it's worth looking through the...
  50. Can you post the complete stack trace? Does...

    Can you post the complete stack trace?

    Does this happen only if the btype dimension is present in the WHERE? You say the behavior is random- does that mean that the exact same query can...
Results 1 to 50 of 696
Page 1 of 14 1 2 3 4