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: