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
    49

    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...
  2. 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,...
  3. 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...
  4. 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...
  5. 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...
  6. Replies
    1
    Views
    69

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

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

    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>',...
  9. Replies
    3
    Views
    281

    Hmmm. Is the mysql driver in your classpath?

    Hmmm. Is the mysql driver in your classpath?
  10. Replies
    3
    Views
    281

    Why are you using the JDK14 (backward...

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

    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...
  12. Replies
    5
    Views
    178

    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...
  13. Replies
    16
    Views
    369

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

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

    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...
  15. Replies
    16
    Views
    369

    Any logging on the biserver side?

    Any logging on the biserver side?
  16. 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?
  17. Replies
    5
    Views
    183

    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...
  18. Replies
    5
    Views
    183

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

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

    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 }
  21. Replies
    3
    Views
    182

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

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

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

    Can you post your schema definition for your...

    Can you post your schema definition for your product dimension?
  24. 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...
  25. 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...
  26. This is worth asking on the Saiku forums.

    This is worth asking on the Saiku forums.
  27. Replies
    5
    Views
    197

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

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

    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,...
  29. Replies
    3
    Views
    216

    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...
  30. Replies
    3
    Views
    216

    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...
  31. 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.
  32. 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.
  33. 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!
  34. 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...
  35. 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...
  36. Replies
    1
    Views
    164

    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
  37. 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:



    ...
  38. Replies
    2
    Views
    155

    A simple option would be to define a...

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

    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...
  40. 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...
  41. Replies
    9
    Views
    805

    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...
  42. 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.
  43. Replies
    9
    Views
    805

    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...
  44. Replies
    5
    Views
    946

    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...
  45. Replies
    9
    Views
    805

    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.
  46. While Mondrian doesn't support clustering, it...

    While Mondrian doesn't support clustering, it *does* support distributed cache. That can provide good options for spreading workload over many servers. See...
  47. Have you defined the User and Password connection...

    Have you defined the User and Password connection properties? Those should be passed in the HTTP header if defined.
  48. Working on schemas, it seems that in some cases a...

    Working on schemas, it seems that in some cases a new version doesn' t not fully remove the old one, leading in inconstancies.
    To be more precise, publishing a new version of a schema may not work....
  49. ==> Which version is used by Pentaho :...

    ==> Which version is used by Pentaho : 3.7.0.0-752 or 3.6.5 ?

    Pentaho 5.1 uses 3.7.0.0-752.
    The Saiku plugin must still have 3.6.5 included in the distribution. I *think* that saiku will pick...
  50. Scanning down the stack trace, the underlying SQL...

    Scanning down the stack trace, the underlying SQL Server error is

    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name
    'abc'.

    Is it possible 'abc' doesn't exist, or...
Results 1 to 50 of 516
Page 1 of 11 1 2 3 4