Hiding a column in pivot table if the column is null in Oracle OBIEE

626 views Asked by At

we are creating a pivot table in OBIEE, we need to hide columns from the pivot table if those columns are null. Is there any implicit way of doing this in Oracle OBIEE? Thanks in advance

1

There are 1 answers

2
Chris On

No you can't. For the very simple reason that a pivot is a cross-table and does intersections of data so you quite literally can never be sure that a whole "column" as you call it retrieves only NULLs. It simmply doesn't make sense.