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

Search Forums:

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

Page 1 of 13 1 2 3 4

Search Forums: Search took 0.09 seconds.

  1. One thing about MDX is that even if you don't...

    One thing about MDX is that even if you don't explicitly include a measure in your query there is always one present in context, typically the default measure for the cube. If your default measure...
  2. Hi kiwitac- Your MDX is about as simple as it...

    Hi kiwitac-
    Your MDX is about as simple as it gets. What's the cardinality of the dimensions in the query? What's the total row/column count of the result when the query finally finishes?

    If...
  3. Can you attach the log file with more than a...

    Can you attach the log file with more than a snippet? (if you click the "Go Advanced" button below there's an attach file option) Make sure to include the MDX you're running. And you're saying the...
  4. Can you provide more details? Is it a specific...

    Can you provide more details? Is it a specific query or queries that bring about this issue? Anything else going on on the server at the time? Can you post any logs from a period of time where...
  5. Replies
    4
    Views
    155

    Within PSW you should be able to put your jar in...

    Within PSW you should be able to put your jar in the plugins dir. In biserver placing it in webapps/pentaho/WEB-INF/lib should work.
  6. Some clients (like Pentaho Analyzer) give you an...

    Some clients (like Pentaho Analyzer) give you an option to "Also Show" parent attributes within a hierarchy, which will display those members without also querying for their aggregated cell values. ...
  7. I'm not as familiar with Saiku as I'd like to be,...

    I'm not as familiar with Saiku as I'd like to be, so I can't really say if it's a bug or as designed. This might be a worthwhile question to ask on their forum. It's not clear to me why they would...
  8. Replies
    4
    Views
    155

    Your class needs to be accessible to Mondrian. ...

    Your class needs to be accessible to Mondrian. Bundling it in a jar and placing the jar on the classpath is a simple way to do that.
  9. Your MDX is asking for a set on the columns...

    Your MDX is asking for a set on the columns including { [2003], [2003].[Jan], [2003].[Feb] }. I.e. the NON EMPTY results include the aggregated totals for [2003]. Saiku must use this hierarchize()...
  10. Replies
    6
    Views
    242

    Jira shows it as currently slated for fix with...

    Jira shows it as currently slated for fix with 6.0.
  11. Replies
    1
    Views
    105

    That's pretty ugly. How reliably can you...

    That's pretty ugly.

    How reliably can you reproduce this? Do you have repro steps? Any exceptions in the logs?

    You can try passing a printwriter in to the cache control to get some trace...
  12. Pentaho Analyzer is an EE only feature. If you'd...

    Pentaho Analyzer is an EE only feature. If you'd like to try it out grab the EE trial download.

    For CE, Saiku and Pivot4j can be found in the marketplace.
  13. Replies
    2
    Views
    167

    Try setting the table value on your ,...

    Try setting the table value on your <Attributes>, just using the same table name as your measure group.

    See the [Store] Cube in Foodmart.mondrian.xml for an example of where degenerates are used: ...
  14. Replies
    1
    Views
    177

    Mondrian supports member properties, which would...

    Mondrian supports member properties, which would allow you to associate the day name with the individual day dimension member (see...
  15. Hmm, it's possible you uploaded the wrong logs. ...

    Hmm, it's possible you uploaded the wrong logs. The "slow" log time shows 56 seconds MDX time, the fast log time just under 11 seconds.

    Leaving the cellBatchSize at 2 billion is not a safe...
  16. Replies
    6
    Views
    242

    Thanks Berkin, I've created...

    Thanks Berkin, I've created http://jira.pentaho.com/browse/MONDRIAN-2323 to capture the issue.

    Just for future reference, the key phrase to start with when reporting these sorts of issues is...
  17. Replies
    6
    Views
    242

    On the github issues list you've pointed out that...

    On the github issues list you've pointed out that selecting 'y' will not give a duration when spanning years. True. With the current implementation of DateDiff these are the supported intervals. ...
  18. Replies
    6
    Views
    242

    You've selected the interval 'd' in your query,...

    You've selected the interval 'd' in your query, which corresponds to the day of month, resulting in 20-19=1. What you want is 'y' (day of year). Here's the list of supported intervals:


    ...
  19. Replies
    7
    Views
    414

    It surprises me that switching to NECJ didn't...

    It surprises me that switching to NECJ didn't make much difference. Can you attach logs again after that change?

    Also, you could try out the same suggestion I made in a different thread today- ...
  20. Hi Claudio, For debugging purposes, try setting...

    Hi Claudio,
    For debugging purposes, try setting the property

    mondrian.rolap.cellBatchSize=2000000000

    It's possible that your large crossjoin is causing Mondrian to exceed the cell batch...
  21. Replies
    7
    Views
    414

    Hi Dharani- So it looks like my guess was right-...

    Hi Dharani-
    So it looks like my guess was right- something about your query and data is causing the creation of a large number of cell requests, enough that Mondrian needs to batch them across...
  22. Replies
    7
    Views
    366

    Well, since you're running in an IDE you can...

    Well, since you're running in an IDE you can always stop on a breakpoint and use a trick like evaluating the expression:

    org.apache.log4j.MDC.class.getProtectionDomain().getCodeSource()
  23. There must be a schema. That said, Pentaho has a...

    There must be a schema. That said, Pentaho has a data source wizard that'll allow you to point to a table or view and auto generates a model. It's necessarily limited, but allows you to get up and...
  24. Replies
    7
    Views
    366

    Hmmm. Not really sure what else to suggest. ...

    Hmmm. Not really sure what else to suggest.

    Is this a custom deployment of Mondrian that you're doing? Or are you using biserver, saiku or something?
  25. Replies
    7
    Views
    366

    There's an open jira case around this to...

    There's an open jira case around this to eliminate use of non-public API methods from Mondrian's use of log4j, unfortunately it hasn't been addressed yet. ...
  26. Replies
    2
    Views
    244

    You've structured your dimension as a hierarchy,...

    You've structured your dimension as a hierarchy, but the attributes are not really hierarchical. Children is not really a parent of Name, which is not a parent of Number. If you need to be able to...
  27. Replies
    6
    Views
    381

    If DEBUG is enabled for mondrian.sql, it should...

    If DEBUG is enabled for mondrian.sql, it should be writing to the configured appenders. If your file is updated correctly I don't really have a guess about what's going on.

    Another option is to...
  28. Replies
    7
    Views
    414

    Sorry for the delay in responding,. Dharani. Do...

    Sorry for the delay in responding,. Dharani. Do you see such bad performance in general, or with specific MDX queries? From your description, I get the sense that your MDX is requiring a very large...
  29. Replies
    7
    Views
    366

    It's possible you have the wrong version of log4j...

    It's possible you have the wrong version of log4j in your classpath somewhere. I'm not sure what version of Mondrian you're running, but a recent one should be using log4j-1.2.14. Can you check...
  30. There's a memory threshold (defaulting to 90%)...

    There's a memory threshold (defaulting to 90%) that trips an error if exceeded. Unfortunately when it trips an error it also is governed by the same logic handling cancellation, which does not...
  31. There was actually a Sybase specific bug fixed...

    There was actually a Sybase specific bug fixed very recently that looks to be to blame (MONDRIAN-2220). I believe it is scheduled to be a part of the March service pack. You can grab one of the...
  32. Oh, sorry- just reread that this was impala, not...

    Oh, sorry- just reread that this was impala, not hive. The cloudera link for that one is here: http://www.cloudera.com/content/cloudera/en/downloads/connectors/impala/jdbc/impala-jdbc-v2-5-16.html
  33. You may already be doing this, but I'd set the...

    You may already be doing this, but I'd set the parameter "PoolNeeded=false" on your Mondrian connection string. That may help reduce likelihood of hitting some of the hive driver threading issues. ...
  34. Replies
    6
    Views
    381

    And just to confirm, you're updating the log4j in...

    And just to confirm, you're updating the log4j in userdir/.schemaWorkbench/log4j.xml, right? Not the one in the folder where workbench.sh lives. If you want the DEBUG output to be directed to...
  35. I'm not aware of anything in the Sybase dialect...

    I'm not aware of anything in the Sybase dialect that could account for those square brackets, or for the convert(varchar during a cardinality query. Very strange.

    Can you add a DEBUG logger for...
  36. There are some cases where a cancel or timeout is...

    There are some cases where a cancel or timeout is not correctly handled. See MONDRIAN-2279. Your case actually looks different than some of the others identified. If you're able to add any repro...
  37. Can you describe the issues you're running into?

    Can you describe the issues you're running into?
  38. Replies
    1
    Views
    203

    Aggregating properties is a bit awkward, and...

    Aggregating properties is a bit awkward, and won't scale very well with larger datasets. One design option to consider is to use a tiny cube with those property values contained in a measure, then...
  39. Replies
    6
    Views
    381

    I'd configure log4j to spit out SQL to see what...

    I'd configure log4j to spit out SQL to see what your segment load query looks like. For workbench you'll need to update log4j.xml in your userdir/.schemaWorkbench/log4j.xml, and add:

    <category...
  40. Replies
    2
    Views
    228

    Cell formatters can give you great flexibility in...

    Cell formatters can give you great flexibility in how a value is displayed. Here's the doc: http://mondrian.pentaho.com/documentation/schema.php#Cell_formatter
  41. Replies
    1
    Views
    204

    A measure can be a string value, although the use...

    A measure can be a string value, although the use case is a little odd. You can define a base measure with datatype="String" and aggregator="max" (or "min"), like this:

    <Measure name="Store...
  42. Replies
    7
    Views
    414

    The key to performance tuning is understanding...

    The key to performance tuning is understanding where the processing time is going. One of my first impulses is always to turn on the mondrian.mdx and mondrian.sql log4j DEBUG loggers just to get a...
  43. Replies
    1
    Views
    185

    There's a "View" drop down in the UI next to the...

    There's a "View" drop down in the UI next to the "Find" box that allows you to select different sort orders. One of those options will honor the sort order within the Mondrian schema. You can also...
  44. What jdbc driver are you using? Also, in your...

    What jdbc driver are you using? Also, in your thread dump, can you see if there's a thread actively handling the statement cancellation?

    I've seen hangs on socket reads in the thrift libraries of...
  45. Thread: Mondrian 3.9

    by mcampbell
    Replies
    1
    Views
    298

    http://jira.pentaho.com/secure/ReleaseNote.jspa?pr...

    http://jira.pentaho.com/secure/ReleaseNote.jspa?projectId=10167&version=13015
  46. That should be a benign warning, particularly if...

    That should be a benign warning, particularly if you're not using JMX monitoring.

    Is it possible you have more than one mondrian server running on your JBoss server? You'd see that error if more...
  47. Replies
    3
    Views
    266

    That may depend on how you build the DSP. If...

    That may depend on how you build the DSP. If it's keying off of some properties unique to 5-threshold people versus 10-threshold people than they should each get their own. Possibly they're each in...
  48. Replies
    2
    Views
    318

    Something like this should work for usage of...

    Something like this should work for usage of Parameter()-

    NON EMPTY Hierarchize(Union(CrossJoin({ Parameter( "year1", [Time], [Time].[2013]) }, {[Measures].[Sales]}), CrossJoin({Parameter(...
  49. Replies
    6
    Views
    285

    Simplest option is to use a full yyyy-mm-dd...

    Simplest option is to use a full yyyy-mm-dd string for the expression used for the [Day] level. If you have need for more flexibility you can use multiple attributes with different expressions, or...
  50. Replies
    6
    Views
    285

    Your best bet is to get those date attributes as...

    Your best bet is to get those date attributes as first class citizens in a denormalized dimension table. If you're at the mercy of grumpy, slow moving DBAs, start pushing them for a sensible schema...
Results 1 to 50 of 638
Page 1 of 13 1 2 3 4