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
    1
    Views
    30

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

    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...
  5. 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...
  6. Replies
    1
    Views
    77

    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...
  7. 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,...
  8. 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...
  9. 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...
  10. 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...
  11. Replies
    1
    Views
    93

    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...
  12. Replies
    4
    Views
    149

    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...
  13. Replies
    4
    Views
    149

    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>',...
  14. Replies
    3
    Views
    309

    Hmmm. Is the mysql driver in your classpath?

    Hmmm. Is the mysql driver in your classpath?
  15. Replies
    3
    Views
    309

    Why are you using the JDK14 (backward...

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

    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...
  17. Replies
    5
    Views
    195

    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...
  18. Replies
    16
    Views
    398

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

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

    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...
  20. Replies
    16
    Views
    398

    Any logging on the biserver side?

    Any logging on the biserver side?
  21. 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?
  22. Replies
    5
    Views
    205

    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...
  23. Replies
    5
    Views
    205

    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...
  24. Replies
    5
    Views
    205

    High cardinality attributes can be a real...

    High cardinality attributes can be a real challenge. Mondrian does a fairly good job w/ big dimensions if native evaluation is used, but there are lots of cases where native evaluation won't kick...
  25. Replies
    2
    Views
    145

    Is it an option for you to use an agg pipeline...

    Is it an option for you to use an agg pipeline expression? E.g.

    { $limit : 10 }
  26. Replies
    3
    Views
    194

    Not sure about the Saiku totaling question--...

    Not sure about the Saiku totaling question-- might be good to try the Saiku forum.
  27. Replies
    3
    Views
    194

    One option is to create calculated members in...

    One option is to create calculated members in your schema which aggregate the set you're interested in. E.g.

    Store.[NE Region 2012] as 'Aggregate( { (Store.[NE Region], Time.[2012] } )'

    That...
  28. Replies
    1
    Views
    132

    Can you post your schema definition for your...

    Can you post your schema definition for your product dimension?
  29. Mondrian does not currently support LookupCube. ...

    Mondrian does not currently support LookupCube. Even in SSAS it's generally discouraged as performance can suffer and there are usually better design alternatives. Is it possible for you to bring...
  30. 1. You could allow anonymous access. Here's...

    1. You could allow anonymous access. Here's some details about how to do that: http://infocenter.pentaho.com/help/index.jsp?topic=%2Fsecurity_guide%2Ftask_removing_security.html If that's not...
  31. This is worth asking on the Saiku forums.

    This is worth asking on the Saiku forums.
  32. Replies
    5
    Views
    200

    IIRC Saiku includes a copy of the mondrian jar in...

    IIRC Saiku includes a copy of the mondrian jar in the plugin lib.
  33. Replies
    5
    Views
    200

    That looks correct to me. Based on the line...

    That looks correct to me.

    Based on the line number of the failure (Util #3734), it looks like the UDF constructor was successfully called with the function name and your class was instantiated,...
  34. Replies
    3
    Views
    222

    Note that jpivot will actually run w/ Mondrian...

    Note that jpivot will actually run w/ Mondrian 3.6 and 3.7. It's just the the Mondrian "war" target bundles up some older libraries that are present in jpivot which need to be swapped out with the...
  35. Replies
    3
    Views
    222

    The mondrian "war" ant target has not really been...

    The mondrian "war" ant target has not really been maintained. It currently bundles up the jpivot war, which has some inconsistent dependencies (e.g. commons logging).

    If you grab a pentaho CE...
  36. When you do a "save as", workbench will pop up a...

    When you do a "save as", workbench will pop up a file save dialog that allows you to choose where the schema is saved.
  37. I'd log a single bug with the two variations. ...

    I'd log a single bug with the two variations. Just make clear that disabling native.nonempty appears to correct the first case.
  38. Yes, please do. If you're able to reproduce it...

    Yes, please do. If you're able to reproduce it with Foodmart that will make it easier for development to fix, but if not attach the demo dataset and schema you used.

    Thanks!
  39. I think you're right- this looks like a bug. It...

    I think you're right- this looks like a bug. It looks like Mondrian's native evaluation logic is getting over-eager in pruning the set of products on the rows, applying the [2014[.[9] context, even...
  40. As things stand right now it's not supported, and...

    As things stand right now it's not supported, and the doc example is wrong. The XMLA spec allows for more than one datasource w/in a server, but Mondrian metadata doesn't fit well with that...
  41. Replies
    4
    Views
    201

    Can you try disabling native topcount to see if...

    Can you try disabling native topcount to see if the error still occurs? Set the following in mondrian.properties:

    mondrian.native.topcount.enable=false
  42. The Parameter function is pretty poorly...

    The Parameter function is pretty poorly documented, but here's some details from an old thread on its use:



    ...
  43. Replies
    2
    Views
    157

    A simple option would be to define a...

    A simple option would be to define a count-distinct measure on pat_id.
  44. Replies
    2
    Views
    217

    Usually the first thing I'd suggest when...

    Usually the first thing I'd suggest when performance tuning is to enable DEBUG logging on the mondrian.mdx and mondrian.sql loggers to see where the time is going. If you have long running SQL...
  45. One option would be to define a...

    One option would be to define a <MeasureExpression> which returns the degree_key when degree_is_visible (or whatever). [Promotion Sales] in the demo Foodmart schema does something similar, although...
  46. Replies
    9
    Views
    809

    Typically Date dimensions are defined in such a...

    Typically Date dimensions are defined in such a way that they are automatically sorted in date ascending order. Because of this, a set like [Time].[Month].members will be sorted w/o need to wrap in...
  47. No problem. And if you want feedback on any of...

    No problem. And if you want feedback on any of your course materials I bet a lot of people on this forum would be more than happy to look through it.
  48. Replies
    9
    Views
    809

    The second parameter tells the Order() function...

    The second parameter tells the Order() function what to order by. Typically that will be a Measure reference, and the set will be ordered based on the measure values. So you probably want to swap...
  49. Replies
    5
    Views
    956

    No impact on data store--Not talking about...

    No impact on data store--Not talking about dimension table, but Mondrian dimension. It sounded earlier in this thread like there is a Type attribute with values (Legal|Physical), and a Name...
  50. Replies
    9
    Views
    809

    Looks like your ORDER function is defined w/ a...

    Looks like your ORDER function is defined w/ a fat nested CJ as the first arg and [Date prelievo].Members as your second arg. The second arg should be a numeric expression, not a set expression.
Results 1 to 50 of 521
Page 1 of 11 1 2 3 4