2 Replies Latest reply: Jun 5, 2014 3:44 AM by 1032227 RSS

    Conditional Column Hiding in OBIEE

    1032227

      Hi All,

       

      We have a requirement like conditionally hide the column based on User's role

       

      We have a report with Following columns

       

      Country_Head     Region_Head     Branch_Head     Branch_Manager     Gross_Sales

       

      If country head views this report, the report structure should be exactly same as above.

       

      If Region head views, the Country head column should not be shown and when Branch Head views it, both Country head and  Region head columns should not be shown and in same way till the leaf level it should be achieved.

       

      Is it possible to achieve this without developing multiple reports.

       

      Thanks In Advance

      Dinesh