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

Question

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

Answer 1

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.