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

Search Forums:

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

Page 1 of 8 1 2 3 4

Search Forums: Search took 0.11 seconds.

  1. When a measure is evaluated against an...

    When a measure is evaluated against an inapplicable dimension at the non-All level, it will result in a NULL value in Mondrian. Since it's not-applicable, Mondrian makes the reasonable assumption...
  2. The function you need is ValidMeasure(), which...

    The function you need is ValidMeasure(), which forces non-applicable dimensions to the all level.

    [Virtual Measure "Cube 1 Measure 1"] / ValidMeasure([Virtual Measure "Cube 2 Measure 2"])
  3. This doesn't help you now, but with Mondrian 4...

    This doesn't help you now, but with Mondrian 4 you'll be able to include multiple hierarchies of a single dimension on an axis, consistent with SSAS. For the time being I'd consider using entirely...
  4. Replies
    4
    Views
    165

    Solve order governs evaluation order when two...

    Solve order governs evaluation order when two calculated members intersect. In the query you posted there is only a single calculated member, which is evaluated in the context of the aggregate total...
  5. I believe I've identified a bug related to what...

    I believe I've identified a bug related to what you're seeing (MONDRIAN-1999). Can you try setting the native filter property to false to see whether you get expected results? I.e. put this in your...
  6. Replies
    1
    Views
    91

    When "[Time].[Date].CurrentMember > [2014-03-03]"...

    When "[Time].[Date].CurrentMember > [2014-03-03]" is evaluated, that is determining the value of the measure value in current context with the Date.CurrentMember and comparing it to the measure value...
  7. Replies
    2
    Views
    114

    The behavior you're seeing surprises me. Unless...

    The behavior you're seeing surprises me. Unless NON EMPTY is specified, the range query you have should result in all members within that range, regardless of whether any measure values are non...
  8. Replies
    4
    Views
    140

    You're getting that error because .members...

    You're getting that error because .members returns a set, which can't be compared to a date. To use a filter, you'd probably want to compare the .CurrentMember.Properties("MEMBER_KEY") to the...
  9. Replies
    4
    Views
    140

    One option would be to use a range with something...

    One option would be to use a range with something like this:

    [TIME.Standard Calendar].[Day].[2013-12-01] : LastNonEmpty( [TIME.Standard Calendar].[Day].members, [Measures].[# of Cases on Orders...
  10. The db connection within PSW is really just there...

    The db connection within PSW is really just there to help with validation and field selection-- it's not necessarily the same database connection you'll ultimate use when you deploy the schema. You...
  11. Good luck, and sorry I couldn't be more help.

    Good luck, and sorry I couldn't be more help.
  12. I don't have an explanation of why the checkbox...

    I don't have an explanation of why the checkbox isn't showing up for the dimension. I think it should show up in your bottom two screenshots.

    If what you're really looking to achieve is to change...
  13. My bad... should have noticed the thread subject....

    My bad... should have noticed the thread subject.

    With MySQL, selecting the database in the connection dialog effectively *is* selecting the schema that will be used. You won't be able to select...
  14. What dbms are you using? To set the connection...

    What dbms are you using?

    To set the connection string you'll need to select "Generic Database" in the connection dialog and enter the connection string in the "Custom Connection" field.
  15. Your screeshot still doesn't show selection of...

    Your screeshot still doesn't show selection of the dimension node. It's the one with 3 arrows in the icon, looks like it's named [Cliente] in your model.

    PSW is a design tool to aid in creating a...
  16. Your screen shots don't show selection of the...

    Your screen shots don't show selection of the Dimension node...try selecting the one with the 3 arrows extending from it. You should see a "Details" section with the dimension name, and a "Time...
  17. Can you say a little more about your use case? ...

    Can you say a little more about your use case? Are you wanting the user to be able to access all members of [Merchant] if <Some client> is in context, and vice vera? Or are you looking for the...
  18. Replies
    2
    Views
    570

    Unfortunately I don't think named sets are...

    Unfortunately I don't think named sets are supported within Saiku. They aren't in Analyzer either, or Pivot4j. Too bad, it could be a very useful feature. Anyone know offhand of a good client that...
  19. If you first select the dimension node in the...

    If you first select the dimension node in the datasource model editor there should be a "Time Dimension" checkbox. Selecting that checkbox should change the options available for each of the levels,...
  20. Replies
    3
    Views
    282

    The mondrian.jar will already be present in your...

    The mondrian.jar will already be present in your installation of biserver. (it's located in biserver-ee/tomcat/webapps/pentaho/WEB-INF/lib).

    It will be used by Pentaho Analyzer, as well as the...
  21. Replies
    4
    Views
    165

    SOLVE_ORDER determines the order of evaluation. ...

    SOLVE_ORDER determines the order of evaluation. Below is a simple example using Foodmart. The [ratio] member is defined with a SOLVE_ORDER of 5. The [sumOfRatios] member SUMs up members. Since...
  22. Hi Michael, Yes, Mondrian is included in the...

    Hi Michael,

    Yes, Mondrian is included in the Pentaho install you're getting ready to do. That will install the Pentaho BI Server, along with Analyzer, which (like Saiku and Pivot4J) is a...
  23. Hi Michael, The instructions you are looking at...

    Hi Michael,
    The instructions you are looking at are a bit outdated. Recent versions placed on sourceforge have not included the .war file. Typically Mondrian is embedded in other applications. If...
  24. Replies
    2
    Views
    110

    You can't mix datatypes in a When expression (or...

    You can't mix datatypes in a When expression (or iif), so you can't have an "NA" as one possible outcome alongside an integer. Luckily, this is better handled with a FORMAT_STRING expression:
    ...
  25. Replies
    1
    Views
    123

    For your first question, I think the properties...

    For your first question, I think the properties below from analyzer.properties are what you'll need to tweak:

    # Max number of filter values to show in UI filter controls
    # such as the date range...
  26. Ok, scratch that last comment-- I *do* see an...

    Ok, scratch that last comment-- I *do* see an issue, but different than yours. Using a 'Date' datatype causes a format exception when the TIMESTAMP literal is parsed as a date literal, which causes...
  27. Sorry- I hadn't noticed you already said that. :)...

    Sorry- I hadn't noticed you already said that. :)

    I was starting to suspect there could be an issue with handling smalldatetime, but I just tried a quick test using smalldatetime with SQL Server,...
  28. What is the type attribute of your ? ...

    What is the type attribute of your <Level>? Should probably be:

    type="Date"
  29. Replies
    6
    Views
    279

    I see 3 MDX queries in your log that ran for...

    I see 3 MDX queries in your log that ran for longer than one second-- the longest of which is a little shy of 6 seconds. It looks like all of these long runners use a range of day level dates. ...
  30. If you're using pentaho biserver, you may be able...

    If you're using pentaho biserver, you may be able to find the error in the pentaho.log. If you're not using biserver, you may need to update the log4j.xml file to get mondrian error logging going...
  31. Date and time datatypes can sometimes be a bit...

    Date and time datatypes can sometimes be a bit finicky- the literal key value needs to jive exactly with the datatype Mondrian is expecting. Unfortunately the stacktrace you posted doesn't include...
  32. Replies
    6
    Views
    1,264

    In the absence of subqueries/subcubes, the...

    In the absence of subqueries/subcubes, the workaround is to define a calculated measure which does the filtering. Something like:

    WITH
    set [Top0] as EXCEPT({[dim2].[Hierarchy].ALLMEMBERS},...
  33. Replies
    6
    Views
    1,264

    No, Mondrian does not currently support...

    No, Mondrian does not currently support subqueries (or sub cubes), although there's an open jira case for the enhancement. What's the use case you need them for?
  34. Replies
    2
    Views
    173

    The way your thinking about the problem is a bit...

    The way your thinking about the problem is a bit at odds with how virtual cubes work. Mondrian will not join together fact tables when evaluating a query against a virtual cube. It will fire...
  35. Replies
    5
    Views
    192

    Completely agree- being able to use named sets is...

    Completely agree- being able to use named sets is useful and powerful. There's a jira case around named sets in Analyzer (http://jira.pentaho.com/browse/ANALYZER-2022). Not clear to me whether that...
  36. You'll get that error if a catalog is not found...

    You'll get that error if a catalog is not found in the datasource you've specified. I'd first want to verify that FoodMart is in your datasource.xml. Second I'd want to check whether the contents...
  37. MongoDB is not currently supported in Mondrian...

    MongoDB is not currently supported in Mondrian (although there is active work on that front). When it *is* supported in Mondrian, however, schema workbench will likely not be supported. Details of...
  38. Replies
    6
    Views
    279

    Can you post the log including the MDX and SQL...

    Can you post the log including the MDX and SQL debug level logging? That might give some clues.
  39. Replies
    5
    Views
    192

    Not sure what client tool you're using, but I...

    Not sure what client tool you're using, but I don't believe Pentaho Analyzer or Saiku support named sets. I don't think they'll show up in the interface.

    In some clients (like Analyzer), sets...
  40. Replies
    3
    Views
    282

    Recent versions placed on sourceforge have not...

    Recent versions placed on sourceforge have not included the .war file. Typically Mondrian is embedded in other applications. If you're a new user interested in kicking the tires of Mondrian you...
  41. I believe this is a solve order issue. Your...

    I believe this is a solve order issue. Your string member is being evaluated in the context of the numeric, hence the error. Try setting the SOLVE_ORDER of [Tendencia] to be higher than [Margen].
    ...
  42. Replies
    13
    Views
    554

    As mentioned in the dev thread you linked to,...

    As mentioned in the dev thread you linked to, there has been some effort toward making Mondrian work with ADOMD.NET and Reporting Services, and these changes may bring us closer to working with...
  43. I think your plan should probably work...extend...

    I think your plan should probably work...extend LocalizingDynamicSchemaProcessor and set the Locale property in filter(), prior to calling super.filter(). IIRC you can you PentahoSessionHolder to...
  44. The connection to Mondrian needs to set the...

    The connection to Mondrian needs to set the locale. I believe Analyzer will pick up the locale from the browser and include that in the connection properties, but I'm not sure if Saiku does the same.
  45. Replies
    1
    Views
    122

    There are not currently good options for modeling...

    There are not currently good options for modeling many-to-many dimensions in Mondrian. There has been recent interest in adding capabilities comparable to SSAS, but I can't say when that will be...
  46. Replies
    1
    Views
    172

    Hi Peter, The samples in .war have not been well...

    Hi Peter,
    The samples in .war have not been well maintained. If you're looking to kick the tires specifically with XMLA you could grab a client like rex (http://sourceforge.net/projects/whex/). ...
  47. Replies
    2
    Views
    1,039

    I'm not sure what your current memory settings...

    I'm not sure what your current memory settings are, but it's worth considering bumping heap.

    If you're seeing out of memory even when Mondrian is evaluating relatively small tuple lists (sounds...
  48. Replies
    1
    Views
    176

    This is a better question for the BI Platform...

    This is a better question for the BI Platform forum. This link should help, though: http://infocenter.pentaho.com/help48/index.jsp?topic=%2Finstall_manual%2Ftask_webapp_context_tomcat.html
  49. The behavior you observe is as expected, and both...

    The behavior you observe is as expected, and both orderings are correct. The .Value function returns the value of the measure in that context. See...
  50. Hi Adam. I think that's a bug. I've logged...

    Hi Adam. I think that's a bug. I've logged MONDRIAN-1920.
Results 1 to 50 of 352
Page 1 of 8 1 2 3 4