The following blog is only for history purpose and is not anymore maintained. The whole style is a mess. Sorry.

Posts Tagged ‘pivot’

Obiee – How to suppress detail rows of a master group in a pivot view ?

Friday, April 10th, 2009

You have detail rows of a group in a pivot table that you want suppress,
We have two solutions :
– if you don’t need a total by “promo Category” (by post or by internet), you can create a new dimension with a formula
– if you want a total by “promo Category”, we must perform a cross conditional formatting.

Obiee Cross conditional formatting on a pivot

Monday, April 6th, 2009

OBIEE does not support cross column conditional formatting in Pivot Tables.
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 in a pivot table.