Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11.1.1.7.150120 Conditional Format Grand Total Row Pivot Table

Received Response
12
Views
3
Comments
jkholmes
jkholmes Rank 1 - Community Starter
edited Aug 13, 2024 7:08PM in Oracle Analytics Cloud and Server

I am having a difficult time adding conditional formatting to the grand total row in a pivot table.  Whenever I add this code:

<saw:conditionalDisplayFormats>

                  <saw:conditionalDisplayFormat>

                     <saw:formatRule>

                        <saw:condition>

                           <sawx:expr xsi:type="sawx:comparison" op="greaterOrEqual">

                              <sawx:expr xsi:type="sawx:columnRefExpr" columnID="cc3c6376606feb070"/>

                              <sawx:expr xsi:type="xsd:decimal">0</sawx:expr></sawx:expr></saw:condition>

                        <saw:formatSpec fontColor="#008000" wrapText="true"/></saw:formatRule></saw:conditionalDisplayFormat></saw:conditionalDisplayFormats>

to the current XML in the <saw:displayGrandTotals> </saw:displayGrandTotals> tag, I get the following error:

View Display Error:

   DXE compiler error.  No table 'GTGTcc9e9c980ae121650c4ee4166a81721f22c99c7f483a5d5d937' found in DXE.  Source Name: DxeAPI. XML: None


Is there a resolution for this error in OBIEE 11.1.1.7.150120?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    where did you got that piece of XML from?

    Isn't it for OBIEE 10g or a really early 11g release?

    The XML definition changed over version, and in 11.1.1.7 that syntax is not supported, the XSD forbid it and it's why you have errors.

    The old way to add conditional formatting on totals doesn't work and as far as I know there is not really an alternative for 11.1.1.7 ...

  • jkholmes
    jkholmes Rank 1 - Community Starter

    I pulled this XML directly from the Advanced tab of my OBI Answers Analysis.  This XML was inside a <saw:displayFormat></saw:displayFormat> tag that was then inside of a <saw:column></saw:column> tag.  As for 12c, is there functionality to add conditional formatting to total rows in a Pivot Table?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Ok, so the XML for the conditional formatting is fine when applied to columns, but you decided by yourself to add it into <saw:displayGrandTotals>, right?

    If it's that then as said you can't, the XSD doesn't allow it ... (and it means there is nothing coded to manage it as well)

    For 12c I didn't hear about that but I didn't test directly that part and I also didn't check in the new XSD to see if something changed for totals in what is allowed or not.