Conditional Formatting Colors are Not Updated When a Refresh is Done in PowerPoint with SmartView for OBIEE (Doc ID 2810314.1)

Last updated on SEPTEMBER 28, 2021

Applies to:

Symptoms

An Analysis with Conditional Formatting is created in OBIEE 12c, and the Pivot Table view is imported into MS Powerpoint (PPT).

In the PPT slide, the data values and their background colors are the same like what are observed in the Analysis results.

Some time passes and the datasource is updated with new data, so when the Analysis is next run, different data values and colors (as per the Conditional Formatting settings) are seen in the results.

But when the PPT file is opened and a Refresh is done, the data values get updated but the "original" background colors are still seen.

For example:

1. Create a simple analysis with a Pivot Table view (Product, Month, Revenue) and a filter on Month.
    Create Conditional Formatting to show green / yellow / red background colors based on the Revenue values.
    Run the analysis with Month = 2021-01 and see values that match all 3 background colors.
    Run the analysis with Month = 2021-02 and see values that match only 2 background colors.

2. In the analysis, set the filter Month = 2021-01 and save the analysis.
    Import the Pivot Table view into PPT, and see the 2021-01 values with all 3 background colors.
    Save and close the PPT file.

3. In the analysis, set the filter Month = 2021-02 and save the analysis.
    Open the same PPT file and do a Refresh, and see the 2021-02 values but still see the same 3 background colors when there should only be 2 background colors.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.