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

Calculated Member not showing when NON EMPTY is on

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.5.0 Suite 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

      If an accumulative Measure sum(YTD(), [measure]) is created, it works fine in the MDX. But if the NON EMPTY option is enabled, it makes it disappear for a particular month when there is no transaction.

      On the Steelwheel Cube, this can reproduced using the following MDX:

      with member [Measures].[MyAccum] as 'Sum(Ytd(), [Measures].[Sales])', FORMAT_STRING = "0"
      select Crossjoin(

      {[Markets].[All Markets]}

      ,

      {[Measures].[Quantity], [Measures].[MyAccum]}

      ) ON COLUMNS,
      NON EMPTY Crossjoin([Product].[All Products].Children,

      {[Time].[All Years].[2005].[QTR2].[Apr], [Time].[All Years].[2005].[QTR2].[May]}

      ) ON ROWS
      from [SteelWheelsSales]
      where [Customers].[All Customers]

      The 'Trucks and Buses' - APRIL and 'Trains' - APRIL do not have real values but they have acumulated value. However after activating NON EMPTY, they disapear.

        PractiTest Integration




          Attachments

            Issue Links

              Activity

                People

                Assignee:
                wgorman Will Gorman (Inactive)
                Reporter:
                rgurjar Rahul Gurjar (Inactive)
                Votes:
                5 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: