OBIEE 11g Pivot Table Conditional Formatting for Grand Totals

Question

Hello,

I have union report which looks like this

the problem here is a i did a column data format on "Monthly Amount" as currency and since this is a union report and YTD is an amount and YTD-1 is an percentage, i did conditional formatting on "Monthly AMount" as where if it is YTD-1 then it should be percentage but this is not applying to "Grand Totals".

I heard this can be done by modifying XML.I tried different options but it is not working. Attached is my xml.

Can some one please help me in fixing this.

Thanks,

Gianni Ceresa · Answer

Conditional formatting on grand totals doesn't work anymore in latest 11g versions and there is no way to make it work as "conditional formatting".

The old hack of the XML doesn't work as the structure changed, in the latest 11g there is a different piece of code that can be accepted by the analysis but then the logic on the server side to apply it is missing, so it's not generating anything (but no error).

So you must find a different approach and find a way to have 2 different columns for your measures YTD and YTD-1.

Try what Asim suggested letting OBIEE "merging and aggregating" your figures (but instead of your current NULLs you will have zeros) or just use OBIEE time series functions like AGO or TO_DATE to calculate YTD-1 on the fly as a second column and get rid of the UNION report or even model the Y-1 at the RPD level.

asim cholas · Answer

Hello,

Instead of having a text column for seggregating ytd1 and ytd 2. try like below

Criteria 1

Billing Region  Ytd 0

Biling region    0    YTD1

Thanks

Asim