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

Search Forums:

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

Page 1 of 9 1 2 3 4

Search Forums: Search took 0.04 seconds.

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

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

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

    Can you post the snippet of your web.xml that shows the DataSourcesConfig value?
  8. 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...
  9. 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.
  10. 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.
  11. 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]...
  12. Replies
    7
    Views
    783

    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.
  13. 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.
  14. Replies
    1
    Views
    1,089

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

    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...
  18. Replies
    1
    Views
    775

    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...
  19. 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...
  20. Replies
    1
    Views
    1,338

    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.
  21. Replies
    3
    Views
    1,424

    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...
  22. Replies
    3
    Views
    1,424

    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.
  23. Replies
    4
    Views
    1,473

    Posting the MDX and full exception contents might...

    Posting the MDX and full exception contents might give some clues.
  24. 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...
  25. Is a SQL exception logged?

    Is a SQL exception logged?
  26. 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...
  27. Does "ant compile" work for you without error? ...

    Does "ant compile" work for you without error? There's some trickery in the build to get it to include supported jdk features, but it's possible that it's not working correctly when compiling tests.
  28. That's a Microsoft error when connecting to your...

    That's a Microsoft error when connecting to your DSN. I'd make sure your system ODBC data source is accessible and configured correctly.
  29. You can create a separate cube on top of the...

    You can create a separate cube on top of the budgets fact table, then bring the two cubes together in a virtual cube. See http://mondrian.pentaho.com/documentation/schema.php#Virtual_cubes for some...
  30. Replies
    2
    Views
    1,221

    If you've got cmdrunner.jar, you can run invoke...

    If you've got cmdrunner.jar, you can run invoke it directly from java. For example, if you're using mysql, you could run

    java -cp...
  31. Replies
    4
    Views
    1,191

    Odd. Can you post a snippet of your schema?

    Odd. Can you post a snippet of your schema?
  32. Replies
    4
    Views
    1,191

    For Postgres, I believe the dialect attribute of...

    For Postgres, I believe the dialect attribute of your <SQL> needs to be 'postgresql', although it should fall back to 'generic' if you've specified a generic variant.
  33. The native properties are enabled by default, so...

    The native properties are enabled by default, so you shouldn't need to do anything if they're commented out.

    It's a bit tricky to guess why it's going against the raw dimension table. There's...
  34. A little bit of background: Mondrian will first...

    A little bit of background: Mondrian will first evaluate the axes of a query, at which point it typically runs SQL to load dimension members. After it's determined the set of cells requested it...
  35. I'm guessing that if you filter by a *single*...

    I'm guessing that if you filter by a *single* member that this will give you expected results, is that right? ClosingPeriod isn't smart enough to determine the correct period when there's a set of...
  36. Replies
    3
    Views
    1,168

    Unfortunately custom aggregators are not...

    Unfortunately custom aggregators are not possible. There's a Jira case for it, and it's been on the roadmap for quite awhile, but hasn't gotten traction. Voting for the case is a way to highlight...
  37. Replies
    2
    Views
    1,789

    Add an ordinalColumn to the Month level. See...

    Add an ordinalColumn to the Month level. See http://mondrian.pentaho.com/documentation/schema.php#Level_Order_and_Display.
  38. Replies
    3
    Views
    740

    Those repeated values are actually each separate,...

    Those repeated values are actually each separate, unique dimension members. E.g. [Time].[2003].[Jan], [Time].[2004].[Jan]. There may be a feature in Saiku that allows treating each of the [Jan]...
  39. Replies
    9
    Views
    916

    Typically you would split your time attributes...

    Typically you would split your time attributes out into a separate table, rather than using degenerate dims. But in principle I don't see why what you're doing won't work.

    One thing I noticed in...
  40. Agreed, the two do not mix well together. I've...

    Agreed, the two do not mix well together. I've created MONDRIAN-2118 to capture the issue. Please add to it if you have any comments (and vote for it).
  41. Replies
    9
    Views
    916

    Just to confirm, if you run a query for just the...

    Just to confirm, if you run a query for just the [YEAR_LVL] you get empty cells as well (even without Gender or anything else in context)? Trying to eliminate variables.

    I still don't have any...
  42. Replies
    9
    Views
    916

    Have you tried a query for just [YEAR_LVL]? ...

    Have you tried a query for just [YEAR_LVL]? Something like

    select [Date].[YEAR_LVL].members on 0 from cubename
  43. A dimension is not necessarily specific to one...

    A dimension is not necessarily specific to one cube.

    Your best option might be to get the list of cubes from the schema, and then walk the cube list looking for the cube or cubes that contain that...
  44. Replies
    2
    Views
    1,033

    Doing that within a dynamic schema processor...

    Doing that within a dynamic schema processor seems like a reasonable option. http://mondrian.pentaho.com/documentation/schema.php#Schema_processor
  45. Replies
    1
    Views
    471

    Best to submit pull requests to master, which is...

    Best to submit pull requests to master, which is used for active development. If the change is determined critical enough for inclusion in a Service Pack it would get backported.

    I'm not sure...
  46. Replies
    9
    Views
    916

    I'm not sure what's going on, but you might be...

    I'm not sure what's going on, but you might be able to learn something by looking at the generated SQL. Try enabling DEBUG on mondrian.sql in log4j.xml.

    <category name="mondrian.sql">
    ...
  47. Replies
    3
    Views
    740

    Maybe [Tipo] should be modeled as a separate...

    Maybe [Tipo] should be modeled as a separate dimension, such that you can filter by the two unique values. That way there wouldn't be a separate [Legal] or [Physical] member under each [Nome].

    If...
  48. Replies
    1
    Views
    465

    Some aggregators obviously don't sum up...

    Some aggregators obviously don't sum up (min/max/count-distinct/avg).

    It's also possible to define a calculated measure which uses conditional checks of .CurrentMember to evaluate different...
  49. Replies
    4
    Views
    438

    Someone else might be able to come up with a...

    Someone else might be able to come up with a clever trick, but the best I can offer is to use a set dimension specific members.

    Won't help you now, but you also may want to vote for...
  50. Replies
    4
    Views
    438

    Unfortunately Mondrian doesn't have the Axis()...

    Unfortunately Mondrian doesn't have the Axis() function.

    In the two example it looks like the calculation is using the value of the first attribute in the tuple on rows. Can you describe the use...
Results 1 to 50 of 448
Page 1 of 9 1 2 3 4