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

  1. 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.
  2. 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!
  3. 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...
  4. 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...
  5. Replies
    1
    Views
    72

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



    ...
  7. Replies
    2
    Views
    75

    A simple option would be to define a...

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

    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...
  9. 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...
  10. Replies
    9
    Views
    735

    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...
  11. 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.
  12. Replies
    9
    Views
    735

    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...
  13. Replies
    5
    Views
    880

    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...
  14. Replies
    9
    Views
    735

    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.
  15. 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...
  16. 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.
  17. 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....
  18. ==> 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...
  19. 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...
  20. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,872

    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.
  21. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,872

    See mondrian.rolap.RolapSchemaUpgrader.

    See mondrian.rolap.RolapSchemaUpgrader.
  22. Replies
    5
    Views
    222

    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.
  23. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,872

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

    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...
  25. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,872

    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...
  26. Replies
    5
    Views
    222

    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...
  27. Replies
    5
    Views
    222

    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. ...
  28. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,872

    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...
  29. 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
  30. Replies
    7
    Views
    1,401

    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?
  31. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,872

    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/
  32. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,872

    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:...
  33. Replies
    6
    Views
    237

    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.
  34. Replies
    6
    Views
    237

    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?
  35. Replies
    6
    Views
    237

    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.
  36. Hi Loren, Can you repost this on the dev list?

    Hi Loren,
    Can you repost this on the dev list?
  37. 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...
  38. 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.
  39. 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...
  40. What version of Mondrian are you running? ...

    What version of Mondrian are you running?

    Based on your schema and query I would expect there to be at least 5 decimal places for your two measures. In fact, with the FORMAT_STRING you have...
  41. You need to set the fact table. Right click on...

    You need to set the fact table. Right click on the cube, select 'Add table', and then on the table node specify the name.
  42. Replies
    2
    Views
    169

    Calculated members defined within the schema...

    Calculated members defined within the schema don't need to show up in the WITH clause. Mondrian knows what the calculation is, and the client doesn't, so the client has neither the ability nor the...
  43. I notice in your logs that the cell request limit...

    I notice in your logs that the cell request limit gets hit many times (~12), which implies the evaluated cell space is pretty large (more than 1.2 million cells).

    The cell req limit is related...
  44. Replies
    7
    Views
    969

    Can you post the snippet of your web.xml that...

    Can you post the snippet of your web.xml that shows the DataSourcesConfig value?
  45. Setting the approximate number is a reasonable...

    Setting the approximate number is a reasonable option to skip some cardinality checks. I expect you'll still have pretty terrible performance though-- 1.7 million members is a huge dim. Do you...
  46. Can you attach your logs during the period when...

    Can you attach your logs during the period when memory spikes? Ideally keep the logs confined to just that limited window of time.
  47. What are the timings in the logs? Are those two...

    What are the timings in the logs? Are those two you listed driving the time? Typically cardinality queries are <100 milliseconds.
  48. Hi Suresh- One option for the MDX side is to...

    Hi Suresh-

    One option for the MDX side is to create calculated members which conditionally shift the current member of the Date dim. So if you wanted previous member of [Time].[Hour 0].[Minute 0]...
  49. Replies
    7
    Views
    969

    Looks like it's unable to find your...

    Looks like it's unable to find your datasource.xml. The location of datasource is set in web.xml. I'd check there and verify the URL.
  50. Any reason you're using separate dimensions for...

    Any reason you're using separate dimensions for date and time? Trying to do determine the Previous hour in MDX will get pretty messy if day and hour are not part of the same hierarchy.
Results 1 to 50 of 485
Page 1 of 10 1 2 3 4