Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-34

Cache-miss causes cells to use wrong format expression

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • 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

        Activity

        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 06/27/2003: status_id, 1 | {jhyde}

        , 06/27/2003: resolution_id, 100 |

        {jhyde}, 06/27/2003: assigned_to, 100 | {jhyde}

        , 06/27/2003: summary, calculated measures evaluation |

        {jhyde}

        , 06/27/2003: close_date, 0

        Show
        Mondrian Importer User added a comment - {jhyde}, 06/27/2003: status_id, 1 | {jhyde} , 06/27/2003: resolution_id, 100 | {jhyde}, 06/27/2003: assigned_to, 100 | {jhyde} , 06/27/2003: summary, calculated measures evaluation | {jhyde} , 06/27/2003: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}

        , 06/27/2003: Logged In: YES
        user_id=312935

        The bug occurs where the format expression uses a measure
        which is not retrieved. The cell format expression is
        calculated after the result has been formed, by which time,
        it's too late to populate the cache.

        Fixed in change 618.

        Show
        Mondrian Importer User added a comment - {jhyde} , 06/27/2003: Logged In: YES user_id=312935 The bug occurs where the format expression uses a measure which is not retrieved. The cell format expression is calculated after the result has been formed, by which time, it's too late to populate the cache. Fixed in change 618.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: