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

  1. Replies
    1
    Views
    103

    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...
  2. 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...
  3. Replies
    4
    Views
    122

    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...
  4. Replies
    4
    Views
    122

    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. ...
  5. Replies
    4
    Views
    122

    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:


    ...
  6. Replies
    7
    Views
    330

    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- ...
  7. 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...
  8. Replies
    7
    Views
    330

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

    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()
  10. 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...
  11. Replies
    7
    Views
    302

    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?
  12. Replies
    7
    Views
    302

    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. ...
  13. Replies
    2
    Views
    179

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

    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...
  15. Replies
    7
    Views
    330

    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...
  16. Replies
    7
    Views
    302

    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...
  17. 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...
  18. 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...
  19. 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
  20. 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. ...
  21. Replies
    6
    Views
    272

    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...
  22. 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...
  23. 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...
  24. Can you describe the issues you're running into?

    Can you describe the issues you're running into?
  25. Replies
    1
    Views
    176

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

    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...
  27. Replies
    2
    Views
    202

    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
  28. Replies
    1
    Views
    183

    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...
  29. Replies
    7
    Views
    330

    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...
  30. Replies
    1
    Views
    154

    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...
  31. 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...
  32. Thread: Mondrian 3.9

    by mcampbell
    Replies
    1
    Views
    258

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

    http://jira.pentaho.com/secure/ReleaseNote.jspa?projectId=10167&version=13015
  33. 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...
  34. Replies
    3
    Views
    261

    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...
  35. Replies
    2
    Views
    298

    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(...
  36. Replies
    6
    Views
    258

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

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

    The date dimension is usually the prime candidate...

    The date dimension is usually the prime candidate to treat hierarchically: Year/Qtr/Month/Day. Once your dimension is structured like that, the sort of query you're trying to do is simple (and...
  39. Replies
    4
    Views
    267

    Yep, that'll work in Analyzer. Just go to User...

    Yep, that'll work in Analyzer. Just go to User Defined Measure|Calculated Measure. If you've got FoodMart loaded up, that expression will work-- although you should use the correct casing of...
  40. Replies
    1
    Views
    215

    Unfortunately there's nothing that makes market...

    Unfortunately there's nothing that makes market basket analysis easy in Mondrian. There has been some solid exploratory work in Mondrian recently around many-to-many relationships, and that may open...
  41. I didn't see a question in there, but if you're...

    I didn't see a question in there, but if you're asking about ID references in MDX, they are possible in Mondrian 3 but only if Ssas compatibility is enabled (mondrian.olap.SsasCompatibleNaming=true)....
  42. Replies
    4
    Views
    267

    MDX offers various functions to roll up sets of...

    MDX offers various functions to roll up sets of members. E.g. you can get a raw count of customers in SF:

    Count( customers.[USA].CA.[San Francisco].children )
  43. Replies
    4
    Views
    219

    manojhytech- If you're asking a PRD question you...

    manojhytech-
    If you're asking a PRD question you may want to ask in that forum. It's also unwise to start a new question in an unrelated thread, even if it's urgent. Just saying.

    Xnoyer-
    Looks...
  44. Replies
    4
    Views
    219

    There needs to be a 1:1 relationship between a...

    There needs to be a 1:1 relationship between a member and it's property value. Consider a property like [has coffee bar] associated with a [Store] member- it would have to have a unique 'Yes' or...
  45. Are you saying there are 296 unique cities within...

    Are you saying there are 296 unique cities within the hierarchy? Or does the same city name occur more than once under different parent members?

    If the latter, keep in mind that in MDX, dimension...
  46. Tell me more about the issues you are running...

    Tell me more about the issues you are running into with virtual cubes with attributes in separate hierarchies. That should not be a problem.
  47. In your example with [January], there are more...

    In your example with [January], there are more than one [January] member, one for each year. It typically doesn't make sense to aggregate all Januarys.

    Similarly with any other hierarchy, members...
  48. Replies
    1
    Views
    207

    There's not a way to disable the validation. ...

    There's not a way to disable the validation. Mondrian needs to validate and resolve the members referenced in any calculations in your schema, which requires these queries. Ideally Mondrian would...
  49. Replies
    2
    Views
    234

    The set in your SUM function needs to sum from a...

    The set in your SUM function needs to sum from a specified starting date up to the current member. Try something like

    SUM( { [Date].[2013].FirstChild : [Date].[Date].CurrentMember...
  50. Replies
    2
    Views
    187

    StrToSet is currently limited to just...

    StrToSet is currently limited to just identifiers- the function reference throws it.

    An alternative that could work in this case is to do a StrToMember, then .Children on that. Like:

    ...
Results 1 to 50 of 625
Page 1 of 13 1 2 3 4