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

Search Forums:

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

Page 1 of 14 1 2 3 4

Search Forums: Search took 0.16 seconds.

  1. Replies
    3
    Views
    125

    You are right, there should be more and better...

    You are right, there should be more and better documentation on this. The idea here is just to include the jointly-applicable attributes in shared dims across the two cubes. This can mean splitting...
  2. For the All member name, by default Mondrian will...

    For the All member name, by default Mondrian will just take the hierarchy name and strap an s on the end. You can set that name to be anything you want, though: ...
  3. Replies
    3
    Views
    125

    What you propose is a reasonable way to go about...

    What you propose is a reasonable way to go about it, i.e. have a split [Year] out into a separate dimension and have that dim shared by both cubes. I've worked with some models that actually had...
  4. You're asking for all members of the [Provinces]...

    You're asking for all members of the [Provinces] level, which does not include the all member. You could try something like

    [Geography.Admin].members

    or

    { [Geography.Admin].[All...
  5. Replies
    4
    Views
    163

    Looking at that again, I think I was making it...

    Looking at that again, I think I was making it way too difficult. Try something like this.

    Aggregate( Tail(Descendants( Time.CurrentMember, Time.Month), 12), measures.[unit sales])
  6. Replies
    4
    Views
    163

    A little verbose, but something like this should...

    A little verbose, but something like this should work for you:

    Aggregate(
    ParallelPeriod( time.month, 12, Tail(Descendants( Time.CurrentMember, Time.Month), 1).Item(0)) :...
  7. Replies
    19
    Views
    343

    That's too bad. Hopefully they'll have a fix...

    That's too bad. Hopefully they'll have a fix soon. I tried out Pivot4J as well, and it also appears to handle totals itself rather than pushing that evaluation to Mondrian.

    I can recommend...
  8. Replies
    19
    Views
    343

    Did a quick scan of Saiku's code and it looks...

    Did a quick scan of Saiku's code and it looks like they're handling totalling internally. See...
  9. When you have multiple grains you want to start...

    When you have multiple grains you want to start thinking about multiple cubes--i.e. create a second cube based on School, including the [student count] measure. You can then bring that cube together...
  10. Replies
    2
    Views
    137

    You can publish from schema workbench. ...

    You can publish from schema workbench. Alternatively you can upload the XML via data source manager (create a new Analysis datasource).
  11. Replies
    19
    Views
    343

    Sorry for bringing up scope isolation before,...

    Sorry for bringing up scope isolation before, that was really more of an aside not intended for this case (but for those curious, it's controlled globally by a property...
  12. I don't know, I haven't had much chance to play...

    I don't know, I haven't had much chance to play around w/ Excel+Mondrian. Defining calculations in the cube is certainly an option, but defeats the flexibility of creating calcs in Excel.

    I have...
  13. Replies
    19
    Views
    343

    SOLVE_ORDER is the key, but missing from this...

    SOLVE_ORDER is the key, but missing from this thread is what the solve order is of the calculated member that's doing the totaling. Solve order governs evaluation order when two calculations...
  14. Unfortunately Mondrian doesn't currently support...

    Unfortunately Mondrian doesn't currently support SESSION MEMBERs. Excel is trying to create one, causing the failure.
  15. That should be it.

    That should be it.
  16. Gotcha. I looked a little closer and found that...

    Gotcha. I looked a little closer and found that the InverseNormal function uses commons-math. That function may or may not work w/ the 3.0. If you're not using InverseNormal than you're probably...
  17. Do you mean Mondrian version 3.0? I wasn't aware...

    Do you mean Mondrian version 3.0? I wasn't aware there was any support for the wilcoxon test back then, and there isn't currently. commons-math also does not currently appear to be a dependency.
  18. Schema Workbench offers more flexibility in model...

    Schema Workbench offers more flexibility in model definition. Of course, most flexible is manual editing of the XML :). Regardless of how you're creating your schema it's worth looking through the...
  19. Can you post the complete stack trace? Does...

    Can you post the complete stack trace?

    Does this happen only if the btype dimension is present in the WHERE? You say the behavior is random- does that mean that the exact same query can...
  20. Interesting. But the list of tables showed...

    Interesting. But the list of tables showed successfully in step 3? Any errors in the log? Which version are you running?
  21. The datasources Mondrian uses is independent of...

    The datasources Mondrian uses is independent of the database used by the platform. I would want to confirm that the datasource you've specified for your Mondrian schema is configured correctly. The...
  22. Replies
    5
    Views
    233

    I don't have a good guess about what's going...

    I don't have a good guess about what's going wrong. If you haven't already, turning on DEBUG logging for AggTableManager can often shed some light on agg table problems.

    <category...
  23. Unfortunately it hasn't been fixed and is not yet...

    Unfortunately it hasn't been fixed and is not yet marked for any upcoming release. If it's important to you I'd vote for the case on Jira, that can boost it's priority.

    In the meantime the fall...
  24. Hmm, so for the [Linea Vacante] rows you want the...

    Hmm, so for the [Linea Vacante] rows you want the [Saldo] measure to be equal to [Presupuesto Aprobado] - the value of Ejecucion at [Persona 2], right? Maybe you want your Saldo measure to be...
  25. Replies
    8
    Views
    410

    It should be included when Pentaho 6.0 is...

    It should be included when Pentaho 6.0 is released.
  26. Replies
    1
    Views
    221

    You could define your [Registrations] measure as...

    You could define your [Registrations] measure as a count of a field on your fact table.
  27. Hi ejeaton, I can't really make out much in your...

    Hi ejeaton,
    I can't really make out much in your screenshot, but if you're looking to have the calculation conditionally performed based on the current [Linea Presupestaria], you shouold be able to...
  28. 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...
  29. 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...
  30. 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...
  31. 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...
  32. Replies
    4
    Views
    235

    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.
  33. 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. ...
  34. 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...
  35. Replies
    4
    Views
    235

    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.
  36. 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()...
  37. Replies
    8
    Views
    410

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

    Jira shows it as currently slated for fix with 6.0.
  38. Replies
    1
    Views
    152

    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...
  39. 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.
  40. Replies
    2
    Views
    269

    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: ...
  41. Replies
    1
    Views
    220

    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...
  42. 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...
  43. Replies
    8
    Views
    410

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

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

    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:


    ...
  46. Replies
    7
    Views
    455

    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- ...
  47. 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...
  48. Replies
    7
    Views
    455

    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...
  49. Replies
    7
    Views
    401

    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()
  50. 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...
Results 1 to 50 of 665
Page 1 of 14 1 2 3 4