OBIEE 11.1.1.7.150120 Conditional Format Grand Total Row Pivot Table

Question

I am having a difficult time adding conditional formatting to the grand total row in a pivot table. Whenever I add this code: 0 to the current XML in the 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?

Gianni Ceresa · Answer

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.

jkholmes · Answer

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

Gianni Ceresa · Answer

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 ...