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

Search Forums:

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

Page 1 of 11 1 2 3 4

Search Forums: Search took 0.08 seconds.

  1. Replies
    2
    Views
    84

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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. Replies
    3
    Views
    155

    Responded in other thread.

    Responded in other thread.
  7. Replies
    1
    Views
    123

    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...
  8. Replies
    1
    Views
    123

    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...
  9. Replies
    3
    Views
    155

    Can you post your time dimension definition?

    Can you post your time dimension definition?
  10. Replies
    4
    Views
    173

    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...
  11. 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.
  12. Can you construct a unit test that reproduces...

    Can you construct a unit test that reproduces this with Foodmart?
  13. 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...
  14. 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) }
  15. Replies
    2
    Views
    155

    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!
  16. Replies
    4
    Views
    173

    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...
  17. 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...
  18. 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...
  19. Replies
    1
    Views
    155

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

    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...
  21. 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. ...
  22. ¿Qué MDX estás ejecutando ?

    ¿Qué MDX estás ejecutando ?
  23. 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...
  24. Replies
    5
    Views
    260

    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...
  25. 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...
  26. 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"
    ...
  27. Replies
    5
    Views
    260

    Try LastNonEmpty( , ) Something...

    Try LastNonEmpty( <set>, <member> )

    Something like:

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

    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.
  29. 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
    ...
  30. 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...
  31. Replies
    4
    Views
    354

    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...
  32. Usually dimension tables should not be very long...

    Usually dimension tables should not be very long (wide, yes, but not very long). What is the cardinality of the [DId] attribute? Are there modeling changes and/or db tuning you could consider to...
  33. Replies
    1
    Views
    143

    Ideally the new "week" attribute would be added...

    Ideally the new "week" attribute would be added to your time dimension table, and then added as a level within the Time dim. You could either have a [Week] level added above [Day], or if you wanted...
  34. To give a little more context for this bug,...

    To give a little more context for this bug, there's the potential to hit in in cases where a calculation within a measure or member changes the context of evaluation. So in Pieter's example above,...
  35. Hi Stuart, There's an ant task for generating...

    Hi Stuart,

    There's an ant task for generating resources ("generate.resources"). If the generated resources are on your classpath you should be able to run tests w/in Eclipse.

    Another thing to...
  36. Mondrian has a feature called "native filter"...

    Mondrian has a feature called "native filter" which will push down parts of the filter constraint to the rdbms. That's where the "having (sum..." is coming from. In general that will improve...
  37. Hi Assassin, You've run into...

    Hi Assassin,
    You've run into http://jira.pentaho.com/browse/MONDRIAN-2218.

    You should be able to get drillthrough to succeed if you select only drillthrough columns that are applicable to the...
  38. Replies
    1
    Views
    160

    Parameter handling is the responsibility of the...

    Parameter handling is the responsibility of the olap client. In Analyzer, for example, you can specify that a filter should be associated with a parameter name, which you can then pass in when the...
  39. Replies
    4
    Views
    223

    Your property name needs to be FORMAT_STRING,...

    Your property name needs to be FORMAT_STRING, like:


    <CalculatedMemberProperty name="FORMAT_STRING" expression="Iif(Value < 0, '|($#,##0.00)|style=red', '|$#,##0.00|style=green')"/>

    Take a...
  40. Replies
    4
    Views
    223

    That looks correct to me. To rule out issues in...

    That looks correct to me. To rule out issues in your format expression you can always try putting it directly in MDX and run it in Saiku, like

    with member measures.blah as '<your measure def>',...
  41. Replies
    3
    Views
    398

    Hmmm. Is the mysql driver in your classpath?

    Hmmm. Is the mysql driver in your classpath?
  42. Replies
    3
    Views
    398

    Why are you using the JDK14 (backward...

    Why are you using the JDK14 (backward compatibility) jars?
  43. Replies
    1
    Views
    164

    There's not a simple way to get that. A single...

    There's not a simple way to get that. A single MDX query may run many SQL queries. The Mondrian monitor keeps a handle on the queries that are executed, but iirc they are cleared out as they...
  44. Replies
    5
    Views
    260

    It usually makes sense to pull and cache the...

    It usually makes sense to pull and cache the values associated with the tuples, since subsequent requests might ask for a subset or overlapping set of those tuples. The aggregate function will sum...
  45. Replies
    16
    Views
    557

    Does the account you're using have permission to...

    Does the account you're using have permission to publish?
  46. Replies
    5
    Views
    260

    Hi Jeff, Have you tried setting: ...

    Hi Jeff,
    Have you tried setting:

    mondrian.rolap.aggregates.optimizePredicates=false

    I can't say I fully understand the behavior you're seeing, but the optimizePredicates property is used to...
  47. Replies
    16
    Views
    557

    Any logging on the biserver side?

    Any logging on the biserver side?
  48. You can create an arbitrarily large number of...

    You can create an arbitrarily large number of measures in Mondrian. How are you trying to create these measures, and what client tool are you using?
  49. Replies
    5
    Views
    286

    One variation of the "link to another report"...

    One variation of the "link to another report" option I should mention-- as of 5.1 Analyzer has a powerful custom actions feature, which allows developers to attach actions to dimension members or...
  50. Replies
    5
    Views
    286

    There's a set of properties (true by default)...

    There's a set of properties (true by default) that govern native evaluation. native.filter, for example, will attempt to push down context and filter constraints to the rdbms when evaluating the...
Results 1 to 50 of 548
Page 1 of 11 1 2 3 4