OBIEE 10G - Cross conditional formatting on a pivot

Saw Object

About

OBIEE does not support cross column conditional formatting in Pivot view. For instance, it's not possible to set a red background of a column based on the value of an other column.

Below is a workaround to be able to perform this kind of formatting and the principal idea is to transform a table view as a pivot table.

Example Data Set

Example : I want to pivot this table from the SH schema :

Promo Category Channel Desc Amount Sold
internet Direct Sales 2,658,953
internet Internet 642,251
internet Partners 1,097,558
NO PROMOTION Direct Sales 115,549,450
NO PROMOTION Internet 26,154,910
NO PROMOTION Partners 51,682,188
post Tele Sales 554,853
TV Direct Sales 696,703
TV Internet 4,166

If the pivot column is the column “Channel Desc”, we have 5 distinct values :

Direct Sales
Internet
Partners
Tele Sales

We create therefore 6 columns :

  • one for the “Promo Category”
  • 4 formula columns for each distinct value of the “Channel Desc”
  • one for the cross conditional formatting

How to transform a table in a pivot

All the details are here :

OBIEE - How to perform a pivot in a table view

Conditional Formatting

After having transformed our table in a pivot, it's finally possible to apply a formatting and to hide the conditional column.

Obiee Conditionnal Formating

Obiee Hide Column

The Result

Obiee Pivot Table Cross Conditional Formatting

This method has a weak point is that you must know the number of distinct value in advance. For instance, if a new distinct value appear in the column “Channel Desc”, you must change your report.

To resolve this issue, you can also achieve a pivot statement with a stored procedure or wait for this functionality.

Below the pivot view :

Obiee Pivot To Format





Discover More
Obiee Goal Suppress Detail Row Of Group
Blog - Obiee 10G – How to suppress detail rows of a master group in a pivot view ?

You have detail row of a group in a pivot table that you want suppress as this : We have two solutions : if you don’t need a total by “promo Category” (by post or by internet), you can create...
Obiee Pivot Measures
OBIEE - Pivot Measures (The Filter Function)

Indicator, description of Measures are generally the sign that you need to pivot your measure (i.e. to create a Pivot Measure) The revenue is booked. Revenue is the measure and booked is a description...
Obiee Goal Suppress Detail Row Of Group
OBIEE 10G - How to suppress detail rows of a master group in a pivot view ?

You have detail row of a group in a pivot view that you want suppress as this : We have two solutions : if you don't need a total by “promo Category” (by post or by internet), you can create...
Saw Object
OBIEE 10G/11G - Pivot View

This view displays results in a pivot table, which provides a summary view of data in cross-tab format. Pivot tables provide the ability to rotate rows, columns, and section headings to obtain different...
Obiee11g Architecture Functional Component
OBIEE 11G - New Features and changes 11G

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is the most significant release of OBIEE since 2006. This article contains the significant changes and new features of OBIEE 11g. Oracle...



Share this page:
Follow us:
Task Runner