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

Search Forums:

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

Page 1 of 12 1 2 3 4

Search Forums: Search took 0.15 seconds.

  1. Replies
    3
    Views
    117

    That may depend on how you build the DSP. If...

    That may depend on how you build the DSP. If it's keying off of some properties unique to 5-threshold people versus 10-threshold people than they should each get their own. Possibly they're each in...
  2. Replies
    2
    Views
    142

    Something like this should work for usage of...

    Something like this should work for usage of Parameter()-

    NON EMPTY Hierarchize(Union(CrossJoin({ Parameter( "year1", [Time], [Time].[2013]) }, {[Measures].[Sales]}), CrossJoin({Parameter(...
  3. Replies
    6
    Views
    111

    Simplest option is to use a full yyyy-mm-dd...

    Simplest option is to use a full yyyy-mm-dd string for the expression used for the [Day] level. If you have need for more flexibility you can use multiple attributes with different expressions, or...
  4. Replies
    6
    Views
    111

    Your best bet is to get those date attributes as...

    Your best bet is to get those date attributes as first class citizens in a denormalized dimension table. If you're at the mercy of grumpy, slow moving DBAs, start pushing them for a sensible schema...
  5. Replies
    6
    Views
    111

    The date dimension is usually the prime candidate...

    The date dimension is usually the prime candidate to treat hierarchically: Year/Qtr/Month/Day. Once your dimension is structured like that, the sort of query you're trying to do is simple (and...
  6. Replies
    4
    Views
    148

    Yep, that'll work in Analyzer. Just go to User...

    Yep, that'll work in Analyzer. Just go to User Defined Measure|Calculated Measure. If you've got FoodMart loaded up, that expression will work-- although you should use the correct casing of...
  7. Replies
    1
    Views
    115

    Unfortunately there's nothing that makes market...

    Unfortunately there's nothing that makes market basket analysis easy in Mondrian. There has been some solid exploratory work in Mondrian recently around many-to-many relationships, and that may open...
  8. I didn't see a question in there, but if you're...

    I didn't see a question in there, but if you're asking about ID references in MDX, they are possible in Mondrian 3 but only if Ssas compatibility is enabled (mondrian.olap.SsasCompatibleNaming=true)....
  9. Replies
    4
    Views
    148

    MDX offers various functions to roll up sets of...

    MDX offers various functions to roll up sets of members. E.g. you can get a raw count of customers in SF:

    Count( customers.[USA].CA.[San Francisco].children )
  10. Replies
    4
    Views
    135

    manojhytech- If you're asking a PRD question you...

    manojhytech-
    If you're asking a PRD question you may want to ask in that forum. It's also unwise to start a new question in an unrelated thread, even if it's urgent. Just saying.

    Xnoyer-
    Looks...
  11. Replies
    4
    Views
    135

    There needs to be a 1:1 relationship between a...

    There needs to be a 1:1 relationship between a member and it's property value. Consider a property like [has coffee bar] associated with a [Store] member- it would have to have a unique 'Yes' or...
  12. Are you saying there are 296 unique cities within...

    Are you saying there are 296 unique cities within the hierarchy? Or does the same city name occur more than once under different parent members?

    If the latter, keep in mind that in MDX, dimension...
  13. Tell me more about the issues you are running...

    Tell me more about the issues you are running into with virtual cubes with attributes in separate hierarchies. That should not be a problem.
  14. In your example with [January], there are more...

    In your example with [January], there are more than one [January] member, one for each year. It typically doesn't make sense to aggregate all Januarys.

    Similarly with any other hierarchy, members...
  15. Replies
    1
    Views
    139

    There's not a way to disable the validation. ...

    There's not a way to disable the validation. Mondrian needs to validate and resolve the members referenced in any calculations in your schema, which requires these queries. Ideally Mondrian would...
  16. Replies
    2
    Views
    163

    The set in your SUM function needs to sum from a...

    The set in your SUM function needs to sum from a specified starting date up to the current member. Try something like

    SUM( { [Date].[2013].FirstChild : [Date].[Date].CurrentMember...
  17. Replies
    2
    Views
    133

    StrToSet is currently limited to just...

    StrToSet is currently limited to just identifiers- the function reference throws it.

    An alternative that could work in this case is to do a StrToMember, then .Children on that. Like:

    ...
  18. Analyzer has just what you need, "Business...

    Analyzer has just what you need, "Business Groups". http://infocenter.pentaho.com/help/index.jsp?topic=%2Fanalysis_guide%2Fconcept_business_groups.html
  19. Replies
    1
    Views
    191

    Yep, it's unfortunate that there's not a simple...

    Yep, it's unfortunate that there's not a simple stand alone demo package anymore. Even when there was a working .war, though, it was a pretty rudimentary app used to get the general idea, with an...
  20. BTW- I've created MONDRIAN-2284 to add native...

    BTW- I've created MONDRIAN-2284 to add native crossjoin support for the asterisk. Doesn't help you now but it should be a benefit to Saiku users in the future.
  21. Hi nra, When there are very large crossjoins...

    Hi nra,
    When there are very large crossjoins that Mondrian hasn't been able to natively reduce (as in this case) Mondrian falls back to the "crossjoin optimizer", which evaluates extra cells to...
  22. To oversimplify a bit, Mondrian evaluates queries...

    To oversimplify a bit, Mondrian evaluates queries by first executing the axes, determing the full set of tuples that form the cellset to be retrieved, and then building out the cell requests...
  23. Thread: MDX Tool

    by mcampbell
    Replies
    4
    Views
    274

    Saiku and Pivot4j are good options. Rex is a...

    Saiku and Pivot4j are good options. Rex is a pretty good tool as well-- if you're using Pentaho you'll need to enable Xmla to the Analysis connections. ( EnableXmla=true )

    The XMLA URL will be...
  24. Replies
    1
    Views
    175

    Native topcount is intended to help with such...

    Native topcount is intended to help with such cases. http://mondrian.pentaho.com/documentation/api/mondrian/olap/MondrianProperties.html#EnableNativeTopCount

    It's enabled by default, and will...
  25. Replies
    5
    Views
    259

    You can omit the cubeName attribute altogether...

    You can omit the cubeName attribute altogether for shared dimensions. cubeName within a <VirtualCubeDimension> is only needed when your specifying that the dimension is defined within a specific...
  26. Replies
    4
    Views
    284

    () Parens designate a tuple, which consists of...

    () Parens designate a tuple, which consists of dimension members from each hierarchy, not a set.

    where ([Product].[Category].[4], [Geography].[Country].[Australia])

    {} Curly braces designate...
  27. Replies
    5
    Views
    259

    You can certainly have virtual cubes with more...

    You can certainly have virtual cubes with more than 2 base cubes. (I've had virtual cubes in production made up of dozens of base cubes without issue). Can you say more about what problems your...
  28. Replies
    5
    Views
    475

    Sorry for the delay in responding, studnev. ...

    Sorry for the delay in responding, studnev. Finally got a chance to try for myself, and yes-- definitely a bug. I reopened your ticket with a new test case. In the meantime the only workaround is...
  29. Replies
    4
    Views
    284

    The only thing different between SSAS and...

    The only thing different between SSAS and Mondrian in for this query is around support for the key references. By default, Mondrian will not recognize the member key references in your slicer (they...
  30. Can you provide any more details? When do you...

    Can you provide any more details? When do you see this error? What do you mean when you say pentaho crashes?
  31. Replies
    5
    Views
    259

    Yea, that's tricky. Once you've introduced the...

    Yea, that's tricky. Once you've introduced the compound slicer of {Time.00 : Time.01} in the WHERE clause, Time.CurrentMember no longer has a valid meaning. Microsoft's SSAS will outright give an...
  32. Alternatively, IIF( [Country].CurrentMember...

    Alternatively,

    IIF( [Country].CurrentMember IS [Country].[USA], [Measures].[Sales], 0)
  33. Replies
    2
    Views
    291

    "Mondrian in Action" covers Mondrian 4 very well:...

    "Mondrian in Action" covers Mondrian 4 very well: http://www.manning.com/back/
  34. Replies
    3
    Views
    205

    There's not any existing method I'm aware of for...

    There's not any existing method I'm aware of for loading a complete cube to cache. Assuming your dimensionality is not enormous, running a set of monster MDX queries could potentially populate the...
  35. Another option I should have mentioned- you could...

    Another option I should have mentioned- you could use a member formatter. See http://mondrian.pentaho.com/documentation/schema.php#Member_formatter.
  36. Your DATE_REG field is probably being interpreted...

    Your DATE_REG field is probably being interpreted as a Timestamp. One option to get the formatting you want is to put it in a sql expression. That is, format the timestamp however you choose in...
  37. Replies
    3
    Views
    205

    Your best option may be to prime the cache with...

    Your best option may be to prime the cache with the most frequently touched data on startup (by running MDX queries).
  38. It's not entirely clear to me why your scenario...

    It's not entirely clear to me why your scenario is not permitted. But, since you have the dim key on the agg table, have you tried just adding the AggForeignKey?

    <AggForeignKey...
  39. Thanks for raising this. It does indeed look...

    Thanks for raising this. It does indeed look like a bug, and I've entered MONDRIAN-2270 for it.
  40. CurrentDateMember works by substituting the...

    CurrentDateMember works by substituting the format strings with the values from the current system time. So your CDM() call executed on the 29th of December would have resulted in [2014].[1] (at...
  41. Mondrian will often join to the fact table when...

    Mondrian will often join to the fact table when resolving dimension members to make sure it's only pulling those that have data. This happens not just when dragging an attribute to the filter...
  42. I believe Luc answered your question on the dev...

    I believe Luc answered your question on the dev list already, but the quick answer is that the highCardinality flag is not safe to use and has been deprecated.
  43. Replies
    1
    Views
    158

    You could wrap exposed measures in a calc that...

    You could wrap exposed measures in a calc that does a simple conditional check. I.e. if [count] is above a threshold then show the measure value, null otherwise.

    It would be nice if Mondrian...
  44. Replies
    5
    Views
    475

    Sounds like an issue with the dialect. Can you...

    Sounds like an issue with the dialect.

    Can you try setting internalType='long' in your schema? If you're starting from an M3 schema that would be added to the <Level>. I think in M4 it's added...
  45. Replies
    2
    Views
    192

    Hi jcrash, There are two useful options for...

    Hi jcrash,

    There are two useful options for linking from an Analyzer report to some other content. The first is to define a FORMAT_STRING expression for a calculated measure which includes a...
  46. Replies
    2
    Views
    220

    There's nothing that supports clearing cache...

    There's nothing that supports clearing cache through XMLA. You don't need to change Mondrian code to add cache clearing capability, however. The cache control API is fairly straightforward...
  47. You could have the attributes both as separate...

    You could have the attributes both as separate hierarchies as well as within a single hierarchy. That would allow doing the sort of filtering you're trying to do as well as keeping the benefit of a...
  48. The rule is that a hierarchy can only be...

    The rule is that a hierarchy can only be explicitly placed on a single axis. The simplest option to get month members filtered by [2014] is just to leverage the hierarchy itself:

    SELECT...
  49. What's the simplest possible query you can...

    What's the simplest possible query you can construct to show the issue? Can you reproduce it with a base measure, or is StdErr a critical part of the problem?

    It's difficult to guess what's...
  50. Replies
    3
    Views
    229

    Responded in other thread.

    Responded in other thread.
Results 1 to 50 of 592
Page 1 of 12 1 2 3 4