Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Medium Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      mondrian 3.1.1.12687
    • 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

      This MDX:

      SELECT
      {[Measures].[Unit Sales]} ON 0,
      VisualTotals({[Customers].[All Customers], [Customers].[USA], [Customers].[USA].[CA], [Customers].[USA].[OR]}) ON 1
      FROM [Sales]

      will return:

      [Customers].[All Customers] 266,773
      [Customers].[All Customers].[USA] 142,407
      [Customers].[All Customers].[USA].[CA] 74,748
      [Customers].[All Customers].[USA].[OR] 67,659

      I think the correct result should be:

      [Customers].[All Customers] 142,407
      [Customers].[All Customers].[USA] 142,407
      [Customers].[All Customers].[USA].[CA] 74,748
      [Customers].[All Customers].[USA].[OR] 67,659

        Activity

        Hide
        Yap Sok Ann added a comment -
        Discover another problem which I think is somewhat related.

        With this MDX:

        WITH SET [CA_OR] AS 'VisualTotals({[Customers].[All Customers], [Customers].[USA], [Customers].[USA].[CA], [Customers].[USA].[OR]})'
        SELECT
            Drilldownlevel({[Time].[1997]}) ON 0,
            [CA_OR] ON 1
        FROM [Sales]

        we will get this for the [Customer].[All Customers] row:

        [Time].[1997] 266,773 (incorrect)
        [Time].[1997].[Q1] 66,291(incorrect)
        [Time].[1997].[Q2] 62,610 (incorrect)
        [Time].[1997].[Q3] 65,848 (incorrect)
        [Time].[1997].[Q4] 72,024 (incorrect)

        If we switch 0 and 1:

        WITH SET [CA_OR] AS 'VisualTotals({[Customers].[All Customers], [Customers].[USA], [Customers].[USA].[CA], [Customers].[USA].[OR]})'
        SELECT
            Drilldownlevel({[Time].[1997]}) ON 1,
            [CA_OR] ON 0
        FROM [Sales]

        we will get this for the [Customer].[All Customers] column:

        [Time].[1997] 266,773 (still incorrect)
        [Time].[1997].[Q1] 36,177 (correct)
        [Time].[1997].[Q2] 33,131 (correct)
        [Time].[1997].[Q3] 35,310 (correct)
        [Time].[1997].[Q4] 37,789 (correct)

        So, we can get different figures by just changing the axis.
        Show
        Yap Sok Ann added a comment - Discover another problem which I think is somewhat related. With this MDX: WITH SET [CA_OR] AS 'VisualTotals({[Customers].[All Customers], [Customers].[USA], [Customers].[USA].[CA], [Customers].[USA].[OR]})' SELECT     Drilldownlevel({[Time].[1997]}) ON 0,     [CA_OR] ON 1 FROM [Sales] we will get this for the [Customer].[All Customers] row: [Time].[1997] 266,773 (incorrect) [Time].[1997].[Q1] 66,291(incorrect) [Time].[1997].[Q2] 62,610 (incorrect) [Time].[1997].[Q3] 65,848 (incorrect) [Time].[1997].[Q4] 72,024 (incorrect) If we switch 0 and 1: WITH SET [CA_OR] AS 'VisualTotals({[Customers].[All Customers], [Customers].[USA], [Customers].[USA].[CA], [Customers].[USA].[OR]})' SELECT     Drilldownlevel({[Time].[1997]}) ON 1,     [CA_OR] ON 0 FROM [Sales] we will get this for the [Customer].[All Customers] column: [Time].[1997] 266,773 (still incorrect) [Time].[1997].[Q1] 36,177 (correct) [Time].[1997].[Q2] 33,131 (correct) [Time].[1997].[Q3] 35,310 (correct) [Time].[1997].[Q4] 37,789 (correct) So, we can get different figures by just changing the axis.
        Hide
        Kurtis Cruzada added a comment -
        Can you please comment on this?
        Show
        Kurtis Cruzada added a comment - Can you please comment on this?
        Hide
        Julian Hyde added a comment -
        Fixed in change 13100 (mondrian-3.1 branch).
        Show
        Julian Hyde added a comment - Fixed in change 13100 (mondrian-3.1 branch).

          People

          • Assignee:
            Julian Hyde
            Reporter:
            Yap Sok Ann
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: