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

Search Forums:

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

Page 1 of 10 1 2 3 4

Search Forums: Search took 0.07 seconds.

  1. Replies
    3
    Views
    80

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

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

    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...
  3. Replies
    1
    Views
    42

    Can you post your schema definition for your...

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

    This is worth asking on the Saiku forums.
  7. Replies
    5
    Views
    138

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

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

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

    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...
  10. Replies
    3
    Views
    123

    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...
  11. 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.
  12. 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.
  13. 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!
  14. 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...
  15. 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...
  16. Replies
    1
    Views
    118

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



    ...
  18. Replies
    2
    Views
    115

    A simple option would be to define a...

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

    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...
  20. 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...
  21. Replies
    9
    Views
    767

    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...
  22. 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.
  23. Replies
    9
    Views
    767

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

    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...
  25. Replies
    9
    Views
    767

    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.
  26. 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...
  27. 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.
  28. 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....
  29. ==> 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...
  30. 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...
  31. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,911

    There are a number of things the upgrader does...

    There are a number of things the upgrader does not handle, and that's certainly one of them. I'd recommend using the upgraded model as a starting point, but manually editing.
  32. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,911

    See mondrian.rolap.RolapSchemaUpgrader.

    See mondrian.rolap.RolapSchemaUpgrader.
  33. Replies
    5
    Views
    236

    I think it would be a very useful feature and I'd...

    I think it would be a very useful feature and I'd love to see it fleshed out. If you do try it out be sure to report back with anything that works unexpectedly.
  34. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,911

    Documentation for the schema def is inside the...

    Documentation for the schema def is inside the distribution zip.
    http://ci.pentaho.com/job/mondrian-4.0/lastSuccessfulBuild/artifact/dist/mondrian-4.0.0-SNAPSHOT.zip
  35. Replies
    5
    Views
    845

    AFAIK, named sets defined within the Mondrian...

    AFAIK, named sets defined within the Mondrian schema will not be exposed in the Saiku interface. Also, I don't believe there is a way to define a named set directly in the UI (apart from maybe...
  36. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,911

    Mondrian 4 uses a new (and very different) schema...

    Mondrian 4 uses a new (and very different) schema definition. See https://github.com/pentaho/mondrian/blob/lagunitas/demo/FoodMart.mondrian.xml for an example.

    M4 will attempt to upgrade a...
  37. Replies
    5
    Views
    236

    You can take a look at some of the test code to...

    You can take a look at some of the test code to get an idea of how to use it: https://github.com/mkambol/mondrian/blob/master/testsrc/main/mondrian/test/ScenarioTest.java, In particular look at the...
  38. Replies
    5
    Views
    236

    Cell write back is supported in Mondrian via the...

    Cell write back is supported in Mondrian via the "Scenario" dimension (http://julianhyde.blogspot.com/2009/06/cell-writeback-in-mondrian.html). Programmatically you can set cell values via olap4j. ...
  39. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,911

    I expect that error points to an issue in your...

    I expect that error points to an issue in your schema. Mondrian 4 does validation of the tables and columns referenced in the schema, is it possible a reference is incorrect? You may be best off...
  40. Virtual cubes allow combining measures from...

    Virtual cubes allow combining measures from multiple cubes, linked by shared dimensionality. See http://mondrian.pentaho.com/documentation/schema.php#Virtual_cubes
  41. Replies
    7
    Views
    1,413

    I've used postgres w/ 5.1 successfully. Can...

    I've used postgres w/ 5.1 successfully.

    Can you post a snippet of your schema including the <SQL> tags, along with the complete stack trace of any error you're seeing?
  42. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,911

    The xmlaserver was split out as a separate...

    The xmlaserver was split out as a separate project. You'll need the olap4j-xmlaserver jar as well.

    http://repo.pentaho.org/artifactory/repo/org/olap4j/olap4j-xmlaserver/1.2.0/
  43. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,911

    To answer your first question, the SNAPSHOT build...

    To answer your first question, the SNAPSHOT build is the latest. The one you probably want to grab is this one:...
  44. Replies
    6
    Views
    250

    mondrian.properties is where it will be read...

    mondrian.properties is where it will be read from. If it's not present in your .prop file, just add an entry for it.
  45. Replies
    6
    Views
    250

    Not sure what you mean by "not getting" the...

    Not sure what you mean by "not getting" the property-- is it not working for you?
  46. Replies
    6
    Views
    250

    If you want to avoid any sort of caching in...

    If you want to avoid any sort of caching in Mondrian try setting

    mondrian.rolap.star.disableCaching=true

    That should force it to always go back to the db to load data.
  47. Hi Loren, Can you repost this on the dev list?

    Hi Loren,
    Can you repost this on the dev list?
  48. There are a lot of factors that can go into how...

    There are a lot of factors that can go into how Mondrian chooses to query the fact table. One that might be relevant here is the cell batch size. Particularly with large dims it's easy to hit the...
  49. Oracle has a number of eccentricities around how...

    Oracle has a number of eccentricities around how its datatypes are represented in JDBC. Glad you found an acceptable workaround.
  50. Try making that HTTP request directly in a...

    Try making that HTTP request directly in a browser (http://localhost:8080/pentaho/api/repo/files/reservedCharacters). You should get prompted for user/pass (if you don't already have a Pentaho...
Results 1 to 50 of 496
Page 1 of 10 1 2 3 4