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

Cache-miss causes cells to use wrong format expression

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • 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 following MDX
      with member [Measures].[xxx] as '[Measures].[Store
      Sales]', format_string = IIf([Measures].[Unit Sales] >
      100000, "AAA######.00","BBB###.00")
      select

      {[Measures].[xxx], [Measures].[Store Cost], [Measures].[Store Sales]}

      ON columns,

      {[Product].[All Products].children} ON rows
      from [Sales]
      where [Time].[1997]

      returns
      AAA48836,21 19.477,23 48.836,21
      AAA409035,59 163.270,72 409.035,59
      AAA107366,33 42.879,28 107.366,33

      this is wrong, rows 1 and 3 should be fromatted "BBB"

      The evaluation woks fine, if the measure Unit Sales is on
      the axis.

      with member [Measures].[xxx] as '[Measures].[Store
      Sales]', format_string = IIf([Measures].[Unit Sales] >
      100000, "AAA######.00","BBB###.00")
      select {[Measures].[xxx], [Measures].[Store Cost], [Measures].[Store Sales], [Measures].[Unit Sales]} ON
      columns,
      {[Product].[All Products].children}

      ON rows
      from [Sales]
      where [Time].[1997]

      returns
      BBB48836,21 19.477,23 48.836,21 24.597
      AAA409035,59 163.270,72 409.035,59 191.940
      BBB107366,33 42.879,28 107.366,33 50.236

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: