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.12 seconds.

  1. Replies
    3
    Views
    98

    () 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...
  2. 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...
  3. Replies
    5
    Views
    369

    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...
  4. Replies
    3
    Views
    98

    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...
  5. 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?
  6. 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...
  7. Alternatively, IIF( [Country].CurrentMember...

    Alternatively,

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

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

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

    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...
  10. 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.
  11. 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...
  12. Replies
    3
    Views
    157

    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).
  13. 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...
  14. 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.
  15. 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...
  16. 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...
  17. 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.
  18. Replies
    1
    Views
    149

    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...
  19. Replies
    5
    Views
    369

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

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

    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...
  22. 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...
  23. 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...
  24. 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...
  25. Replies
    3
    Views
    213

    Responded in other thread.

    Responded in other thread.
  26. Replies
    1
    Views
    140

    Your [Time] dimension has a top level [Time]...

    Your [Time] dimension has a top level [Time] level defined using the same column as the bottom level [Year] column, which is very odd. Also odd that you have [season] defined with a quarter level...
  27. Replies
    1
    Views
    166

    Not sure if I understand what you're trying to...

    Not sure if I understand what you're trying to do, but it is possible to use SQL expressions in definition of keys within your schema. See...
  28. Replies
    3
    Views
    213

    Can you post your time dimension definition?

    Can you post your time dimension definition?
  29. Replies
    4
    Views
    240

    I mentioned below that Pentaho Analyzer will...

    I mentioned below that Pentaho Analyzer will display member properties via a right click option--no need to manually touch MDX. Last I checked Saiku didn't have an option to display them. Not sure...
  30. Agreed, awful. SSAS and IBM Dynamic Cubes both...

    Agreed, awful. SSAS and IBM Dynamic Cubes both have good solutions to handling mixed granularity, and I'd love to see Mondrian improve in this area.
  31. Can you construct a unit test that reproduces...

    Can you construct a unit test that reproduces this with Foodmart?
  32. There was a thread on this topic on the dev list...

    There was a thread on this topic on the dev list awhile back. http://lists.pentaho.org/pipermail/mondrian/2014-February/004782.html

    Bottom line is that the functionality is not fully baked and...
  33. What exactly are you trying to do? The result...

    What exactly are you trying to do?

    The result of CJ is a set of tuples. A tuple set can also be enumerated directly, e.g.

    { (Dim1.A, Dim2,X), (Dim1.B, Dim2.Y) }
  34. Replies
    2
    Views
    198

    This looks like a bug to me, too. Please enter a...

    This looks like a bug to me, too. Please enter a jira ticket. Thanks!
  35. Replies
    4
    Views
    240

    Member properties can be accessed via MDX...

    Member properties can be accessed via MDX (http://msdn.microsoft.com/en-us/library/ms144821.aspx).

    Many MDX clients also provide some way of viewing properties, for example in Analyzer there's a...
  36. Wow, that's a monster compound slicer. It's a...

    Wow, that's a monster compound slicer. It's a little hard for me to visually parse, but I'm guessing you're using UNION'd crossjoins because you want to roll up disjoint intersections. That should...
  37. It's a little difficult to guess what the problem...

    It's a little difficult to guess what the problem with a calculated member is without seeing the calculated member. Can you post your MDX? Even better, if you're able to reproduce the problem with...
  38. Replies
    1
    Views
    171

    The median aggregator is not currently supported,...

    The median aggregator is not currently supported, although there's certainly been interest in supporting it (as well as use of custom aggregators). Comment on and vote for MONDRIAN-570.

    Often,...
  39. Replies
    2
    Views
    236

    Can you post the complete error? My guess is the...

    Can you post the complete error? My guess is the indic_dpr3_ccou.IdRegul column is not accessible from jdbc for some reason (is the naming correct? The casing? account permissions?)

    Note that...
  40. You're right, the dev and install instructions...

    You're right, the dev and install instructions could definitely stand an update.

    Try grabbing the project from github (https://github.com/pentaho/mondrian) and just running the default ant task. ...
  41. ¿Qué MDX estás ejecutando ?

    ¿Qué MDX estás ejecutando ?
  42. Hola , ¿Hay otros errores en el registro ? Tengo...

    Hola ,
    ¿Hay otros errores en el registro ? Tengo curiosidad para ver si alguno de los registros se originan con Mondrian .

    También, puede valer la pena tratar de utilizar Saiku u otro cliente de...
  43. Replies
    5
    Views
    285

    Hi Luis- sorry for the delay in getting back to...

    Hi Luis- sorry for the delay in getting back to you.

    Yes, I've used the function with success. One thing to be aware of is that it will determine the LastNonEmpty member in every context it is...
  44. Unfortunately no. Drillthrough doesn't offer...

    Unfortunately no. Drillthrough doesn't offer that sort of fine grained control.

    One alternative would be to not use drillthrough, but add a link to a SQL report that has the security model you...
  45. I wonder if Mondrian is incorrectly inferring the...

    I wonder if Mondrian is incorrectly inferring the datatype of the [Procuct] level. Oracle jdbc metadata is notoriously difficult to interpret.

    Try adding the attribute

    internalType="long"
    ...
  46. Replies
    5
    Views
    285

    Try LastNonEmpty( , ) Something...

    Try LastNonEmpty( <set>, <member> )

    Something like:

    [Measures].[sales end] AS '(LastNonEmpty([Time.Weeks].[Day].Members, Measures.[sales]), [Measures].[sales])'
  47. Replies
    5
    Views
    285

    Not sure what you mean by "match the earlier...

    Not sure what you mean by "match the earlier date". Are you looking for something like the value from the previous parallel period? A concrete example might help.
  48. The Hierarchize() function you're passing to...

    The Hierarchize() function you're passing to TopCount mixes 2 different levels of a dimension. That function will return an ordered set of members like:

    dimension.level1member
    ...
  49. That's unexpected. The list of columns shown in...

    That's unexpected. The list of columns shown in workbench is retrieved directly from the JDBC metadata. If you've added a column and restarted workbench the list should be refreshed. Is it...
  50. Replies
    4
    Views
    404

    So now the question is why it didn't work with...

    So now the question is why it didn't work with native.topcount enabled. I notice MySQL choked when setting

    SQL_SELECT_LIMIT=10

    But I'm surprised to see that being set at all... what version...
Results 1 to 50 of 567
Page 1 of 12 1 2 3 4