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

  1. Replies
    4
    Views
    620

    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.
  2. 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...
  3. 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.
  4. 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....
  5. ==> 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...
  6. 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...
  7. Thread: Mondrian 4

    by mcampbell
    Replies
    14
    Views
    1,774

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

    by mcampbell
    Replies
    14
    Views
    1,774

    See mondrian.rolap.RolapSchemaUpgrader.

    See mondrian.rolap.RolapSchemaUpgrader.
  9. Replies
    5
    Views
    168

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

    by mcampbell
    Replies
    14
    Views
    1,774

    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
  11. Replies
    5
    Views
    791

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

    by mcampbell
    Replies
    14
    Views
    1,774

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

    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...
  14. Replies
    5
    Views
    168

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

    by mcampbell
    Replies
    14
    Views
    1,774

    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...
  16. 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
  17. Replies
    7
    Views
    1,338

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

    by mcampbell
    Replies
    14
    Views
    1,774

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

    by mcampbell
    Replies
    14
    Views
    1,774

    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:...
  20. Replies
    6
    Views
    204

    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.
  21. Replies
    6
    Views
    204

    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?
  22. Replies
    6
    Views
    204

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

    Hi Loren,
    Can you repost this on the dev list?
  24. 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...
  25. 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.
  26. 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...
  27. 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...
  28. 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.
  29. Replies
    2
    Views
    153

    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...
  30. 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...
  31. Replies
    7
    Views
    912

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

    Can you post the snippet of your web.xml that shows the DataSourcesConfig value?
  32. 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...
  33. 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.
  34. 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.
  35. 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]...
  36. Replies
    7
    Views
    912

    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.
  37. 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.
  38. Replies
    1
    Views
    1,171

    Try defining your calc against the dimension,...

    Try defining your calc against the dimension, instead of as a child member. Like

    WITH member [Time].[example] AS 'AGGREGATE({[Time].[Months].[Jan], [Time].[Months].[Feb]})'
    SELECT
    NON EMPTY...
  39. You probably want something more like ...

    You probably want something more like

    measures.[max] - (Time.CurrentMember.PrevMember, measures.[max])

    You may also want to wrap an iif() condition around the whole thing to specially handle...
  40. It's sorting the members. That's probably not the...

    It's sorting the members. That's probably not the source of your performance problems. I'd set DEBUG logging just on mondrian.sql and mondrian.mdx and start by looking at just the timings of sql and...
  41. Replies
    7
    Views
    912

    I'd take a look in the logs and see if you can...

    I'd take a look in the logs and see if you can find the full stacktrace.

    BTW-- xmlaTest.jsp hasn't really been maintained. It's been awhile since I've used it, but iirc the datasource name in the...
  42. Replies
    1
    Views
    830

    Not sure why you're getting that error, but I'd...

    Not sure why you're getting that error, but I'd suggest using a more dynamic way of retrieving the current month, e.g.

    LastNonEmpty( [Time.Monthly].[Month].members, measures.[My Measure])

    No...
  43. Turning on DEBUG logging might give you some...

    Turning on DEBUG logging might give you some insight into where the time is going. Setting the mondrian.mdx and mondrian.sql log4j loggers to DEBUG will log both the queries themselves as well as...
  44. Replies
    1
    Views
    1,406

    Rex can be a good choice...

    Rex can be a good choice (http://sourceforge.net/projects/whex/). Also, some tools (like Saiku and Pivot4j) have MDX modes.
  45. Replies
    3
    Views
    1,518

    Typically you'd open the Data Source dialog,...

    Typically you'd open the Data Source dialog, click the + icon in the upper right, and select JDBC first. This will allow you to create, configure, and test the database connection to your star. You...
  46. Replies
    3
    Views
    1,518

    Verify your server info and user/password are...

    Verify your server info and user/password are correct.

    If you're using 5.0+, you can also upload the Mondrian schema xml via the "Manage Data Sources" dialog.
  47. Replies
    4
    Views
    1,580

    Posting the MDX and full exception contents might...

    Posting the MDX and full exception contents might give some clues.
  48. That's a difficult question to ask within an MDX...

    That's a difficult question to ask within an MDX formula. I'd be worried about performance.

    Could you create a separate cube that consists of daily or monthly snapshots of product cost? That...
  49. Is a SQL exception logged?

    Is a SQL exception logged?
  50. I don't have an immediate guess on what's wrong,...

    I don't have an immediate guess on what's wrong, but a couple things I'd want to try first.
    1) Does 'SELECT FROM [LTVCube]' work? That's the simplest possible query you can run, and validates...
Results 1 to 50 of 472
Page 1 of 10 1 2 3 4