Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-960

Ability to define non-measure calculated members in a cube under a specifc parent

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: 3.2.1 GA (3.7.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None
    • Customer Case:
    • QA Validation Status:
      Validated by QA

      Description

      Add support for defining non-measure calculated members in a cube under a specifc parent. Currently, any non-measure calculated members such as [Product].[Drink+Food] can only be defined under the (All) level. I would like to place my calculated members under specific parents such as the All Member or Food member. There should also be an API to also retrieve these calculated member by Level. When executing Level.Members, these calculated members should not be returned to maintain existing behavior.

        Activity

        Hide
        Julian Hyde added a comment -
        Makes sense.

        Regarding whether they are included in expression results, see http://msdn.microsoft.com/en-us/library/ms146077.aspx (AddCalculatedMembers and StripCalculatedMembers).
        Show
        Julian Hyde added a comment - Makes sense. Regarding whether they are included in expression results, see http://msdn.microsoft.com/en-us/library/ms146077.aspx (AddCalculatedMembers and StripCalculatedMembers).
        Hide
        Julian Hyde added a comment -
        When fixing this, please also make sure that it works with ssas-compatibility enabled, in a dimension with multiple hierarchies. For example:

        with member [Time].[Weekly].[Foo] as ...
        select ... [Weekly].[Foo]

        In other words, you should be able to define with one path, and reference with another. In this case the fully-qualified name is [Time].[Weekly].[1997].[Foo] but you should be able to use an abbreviated name like [Weekly].[1997].[Foo].

        This will be needed in mondrian-4, because the fully-qualified-name of a measure is [Measures].[Measures].[Store Sales]. Look for Bug.BugMondrian960Fixed; I will be using this flag to put in some short-term hacks.
        Show
        Julian Hyde added a comment - When fixing this, please also make sure that it works with ssas-compatibility enabled, in a dimension with multiple hierarchies. For example: with member [Time].[Weekly].[Foo] as ... select ... [Weekly].[Foo] In other words, you should be able to define with one path, and reference with another. In this case the fully-qualified name is [Time].[Weekly].[1997].[Foo] but you should be able to use an abbreviated name like [Weekly].[1997].[Foo]. This will be needed in mondrian-4, because the fully-qualified-name of a measure is [Measures].[Measures].[Store Sales]. Look for Bug.BugMondrian960Fixed; I will be using this flag to put in some short-term hacks.
        Hide
        Julian Hyde added a comment -
        Made the necessary code changes in change 14560.

        Close bug when necessary tests have been implemented. See TODOs in SchemaTest.testCalcMemberInCube.

        Consider moving to 3.3, since the hard work has been done.
        Show
        Julian Hyde added a comment - Made the necessary code changes in change 14560. Close bug when necessary tests have been implemented. See TODOs in SchemaTest.testCalcMemberInCube. Consider moving to 3.3, since the hard work has been done.
        Hide
        Luc Boudreau added a comment -
        Added a bunch of tests in rev. 14980 in //open/mondrian.

        I've also added some more explicit error messasges instead of the generic "NamedSet has bad formula".
        Show
        Luc Boudreau added a comment - Added a bunch of tests in rev. 14980 in //open/mondrian. I've also added some more explicit error messasges instead of the generic "NamedSet has bad formula".
        Hide
        Will Gorman added a comment -
        I verified that the unit tests are passing in CI
        Show
        Will Gorman added a comment - I verified that the unit tests are passing in CI

          People

          • Assignee:
            Unassigned User
            Reporter:
            Benny Chow
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: