Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-1226

Set on slicer axis with different behaviour than aggregated member of same set in the slicer

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.5.0 GA (4.8.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None
    • Story Points:
      2
    • 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 query:

      with set a as '([Time].[1997].[Q1] : [Time].[1997].[Q2])'
      member Time.x as Aggregate(a,[Measures].[Store Sales])
      member Measures.x1 as ([Time].[1997].[Q1],[Measures].[Store Sales])
      member Measures.x2 as ([Time].[1997].[Q2],[Measures].[Store Sales])
      set products as TopCount(Product.[Product
      Name].Members,1,Measures.[Store Sales])
      SELECT
      NON EMPTY products ON 1,
      NON EMPTY

      {[Measures].[Store Sales], Measures.x1, Measures.x2} ON 0
      FROM [Sales]
      – where ([Time].[1997].[Q1] : [Time].[1997].[Q2])
      where Time.x


      Returns:

      Urban Small Eggs
      497.42
      235.62
      261.80


      While this:



      with set a as '([Time].[1997].[Q1] : [Time].[1997].[Q2])'
      member Time.x as Aggregate(a,[Measures].[Store Sales])
      member Measures.x1 as ([Time].[1997].[Q1],[Measures].[Store Sales])
      member Measures.x2 as ([Time].[1997].[Q2],[Measures].[Store Sales])
      set products as TopCount(Product.[Product
      Name].Members,1,Measures.[Store Sales])
      SELECT
      NON EMPTY products ON 1,
      NON EMPTY {[Measures].[Store Sales], Measures.x1, Measures.x2}

      ON 0
      FROM [Sales]
      where ([Time].[1997].[Q1] : [Time].[1997].[Q2])
      – where Time.x

      returns:

      Urban Small Eggs
      497.42
      497.42
      497.42

      I'd expect the first one to be the correct result

        PractiTest Integration




          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                pmalves Pedro Alves
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: