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

After change 13351 all Excel pivots fail to update. CellInfo element in XMLA response is wrong.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 3.2.0 GA (3.6.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None
    • Environment:
      Mondrian - SimbaO2X provider - Excel 2007
    • 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

      After change
      MONDRIAN: Distinguish XMLA requests for member and cell properties. (Fix for
      Excel 2007 compatability, contributed by Sergey Mazin.)
      Move XMLA enums and constants into olap4j.

      all excel pivots fail.

      The problem is in CellInfo element in XMLA response.

      It is:
      <CellInfo>
      <Value name="VALUE"/>
      <FormatString name="FORMAT_STRING"/>
      </CellInfo>

      Should be:
      <CellInfo>
      <Value name="VALUE"/>
      <FormatString name="FORMAT_STRING"/>
      <Language name="LANGUAGE"/>
      <BackColor name="BACK_COLOR"/>
      <ForeColor name="FORE_COLOR"/>
      <FontFlags name="FONT_FLAGS"/>
      </CellInfo>

        Attachments

        1. Property.java
          30 kB
        2. XmlaCognosTest.ref.xml
          6.54 MB
        3. XmlaExcel2007Test.java
          5 kB
        4. XmlaExcel2007Test.ref.xml
          135 kB
        5. XmlaHandler.java
          121 kB

          Activity

            People

            Assignee:
            jhyde Julian Hyde (Inactive)
            Reporter:
            sergey.mazin Sergey Mazin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: