Adding conditional formating to BI Publisher Pivot table on Excel

Chaima Rahali

Hello Team,

I am trying to add conditional formatting to a pivot table I have created on Excel BI Publisher :

For this table for example I have added two conditions on the data cell :

But when I published this template I can see that only the first condition is applied and so with excel conditional formatting we can only apply one condition on the same field,

Is there another way to apply multiple conditional formatting on BI Publisher Pivot table on Excel ?

Thanks,

Chaima.

Mallikarjuna Kuppauru-Oracle

Hi @Chaima Rahali

I saw you have logged an SR for the same , we checked with Dev team on this and this is an product behavior/limitation. There is no workaround available .

https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/introduction-excel-templates.html#GUID-8EECB42F-783C-4599-868B-BC1C3994B660 —> Limitations of Excel Templates

When you use an Excel template, you can't use conditional formatting based on the generated data to change the background color of a cell in the report output.

We are working internally to add the same to product documentation. i hope we have answered your question. can you pls mark it as Answered.

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @Chaima Rahali

You can check below for examples -

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2480

Regards,

Arjun

Chaima Rahali

Hello @Mallikarjuna Kuppauru-Oracle

Thank you for the quick response,

I reviewed this documentation but I believe it is for Microsoft Word, not Excel,

also, this is for a regular table and not a Pivot one, I have noticed that BIP conditional formatting does not apply to the pivot table.

Regards,

Chaima.

Mallikarjuna Kuppauru-Oracle

Hi @Chaima Rahali

Yes previous link for RTF , can you refer below -

https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#BIPRD2747

See the Note in Prerequisites section - Excel 2003 allows only three conditional formatting rules per cell, but Excel 2007 allows more.

I have not noticed any limitation for pivot table .

Regards,

Arjun