Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Conditional Formatting based on a columnd and a row in 12c

Received Response
11
Views
3
Comments
3427576
3427576 Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hi All,

I would like to create a report using conditional formatting. I want a field to be formatted based on two conditions. one based on column and the other based on row. As highlighted in the image(red circles), only the intersecting fields should be formatted according to the given condition. I am using normal table (not the pivot) to do this.

FYI,

pastedImage_1.png

column level conditional formatting:

pastedImage_2.png

Row level conditional formatting:

pastedImage_3.png

I also noticed that the output is strange. Although I applied same formatting for the four columns the output is not same.

I want the report to be formatted as shown in the below image. In the column level gap I have inserted the Variance % column. Kindly share your ideas to achieve this.

Thanks in advance

pastedImage_4.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Conditional formatting based on 2 or more conditions is possible. The GUI way to make it would be by adding new columns to your analysis where you write formulas returning flags. The issue with your case is that you are using a table view, so that approach will not work because each column is independent.

    You can still try the "other" option: hacking slightly the XML of the analysis.

    https://www.rittmanmead.com/blog/2014/03/the-secret-life-of-conditional-formatting-in-obiee/

    I wrote it years ago using 11.1.1.7 but I'm kind of sure it still works in 12c as I didn't notice big changes in the XML on that side.

  • 3427576
    3427576 Rank 4 - Community Specialist

    Thanks for your reply.

    I will try the solution with XML.

    Mean while could you tell me without table view, which other view I need to use and how to format it.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Well, you can use a pivot.

    You seems to have 4 columns (ACT, BUD, Variance and Variance %) which are repeated by some attributes.

    In that case using hidden columns calculating flags will work. So you move the "condition" from the XML into the formula of the column (so it's visible and easy to maintain).

    But it depends on your model ...