You have detail row of a group in a pivot view that you want suppress as this :
We have two solutions :
if "promo category" = internet then suppress the value
Click on the formula icon and enter this formula to create a new combine dimension :
CASE WHEN Promotions."Promo Category" = 'post' THEN Products."Prod Category" ELSE 'Post' END
It remains to remove the column Promotions.“Promo Category” from the pivot view with a drag and drop of it in the exlcuded area and you get :
Unfortunately, the cross conditional formatting is not yet supported by OBIEE in a pivot view ( OBIEE 10G - Cross conditional formatting on a pivot)
We must go therefore back to a table view, pivot the table and apply a css property to suppress the detail rows. ( To know more about what is and how to pivot a table in a table view : OBIEE - How to perform a pivot in a table view )
We must pivot the table on the column “Channel Desc”. This column as 5 distinct values :
Direct Sales
Internet
Partners
Tele Sales
We create therefore 6 columns :
In each column of “Channel Desc”, we insert a filter formula.
Example for the column “Direct Sales”
Column | Formula |
---|---|
Direct Sales | FILTER(“Sales Facts”.“Amount Sold” USING (Channels.“Channel Desc” = 'Direct Sales')) |
Internet | FILTER(“Sales Facts”.“Amount Sold” USING (Channels.“Channel Desc” = 'Internet')) |
Partners | FILTER(“Sales Facts”.“Amount Sold” USING (Channels.“Channel Desc” = 'Partners')) |
Tele Sales | FILTER(“Sales Facts”.“Amount Sold” USING (Channels.“Channel Desc” = 'Telesale')) |
The table is nu in a pivot form and we can apply the conditional formatting to suppress the detail record.
In each column of the report, you must add this conditional formatting in the column properties :
Promo Category is equal to / is in internet
and add this css property to hide the values :
display:none
Example :
And you get :