Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1 GA
    • Fix Version/s: Future Release
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      The query

      select
        {[Measures].[Store Sales],[Gender].[M]} on columns,
        {[Store].[All Stores].[USA].children} on rows
      from Sales

      gives values for ([Measures].[Store Sales], [Gender].[All
      Gender]) in the 2nd column, but it should be the default
      measure, ([Measures].[Unit Sales], [Gender].[M]).

      The problem is that the axis is heterogeneous --
      [Measures].[Store Sales] and [Gender].[M] are from
      different hierarchies -- and mondrian optimizes query
      execution by assuming that they are homogeneous.

      For now, we should throw an error that we do not
      support heterogeneous axes. (MSOLAP does not.)

      If we ever allow heterogeneous axes, we need to be
      more selective how we apply the optimization.

        Activity

        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 04/08/2003: priority, 5
        Show
        Mondrian Importer User added a comment - {jhyde}, 04/08/2003: priority, 5
        Hide
        Julian Hyde added a comment -
        In SSAS 2005 this query is an error. Added test case BasicQueryTest.testHeterogeneousAxis. Change 12587, will be in mondrian-3.1.1.
        Show
        Julian Hyde added a comment - In SSAS 2005 this query is an error. Added test case BasicQueryTest.testHeterogeneousAxis. Change 12587, will be in mondrian-3.1.1.
        Hide
        Priya Muraleedharan added a comment -
        This issue has been fixed and validated using 3.7.0-M1 build on 27/SEP/2010
        Show
        Priya Muraleedharan added a comment - This issue has been fixed and validated using 3.7.0-M1 build on 27/SEP/2010

          People

          • Assignee:
            Julian Hyde
            Reporter:
            Julian Hyde
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: