Get Started with Redwood for Oracle Cloud HCM Begin Now
How to have Pivot in BIP based on a Logical SQL Pivot OTBI Report.
Summary
An OTBI Report is built based on Pivot View and based on the Logical SQL of that OTBI Report , a BIP Report is built but there the Pivoting is not working as Expected.Content
An OTBI Report is built based on Pivot View and based on the Logical SQL of that OTBI Report , a BIP Report is built but there the Pivoting is not working as Expected.
In OTBI ,a coulmn named as Identifier Type where all the ID'S are included and in order to capture the NULL values for the Identifier Type( Those persons who dont have any identifier) Otbi Pivot table is used where the Id's are shown as Column wise(E.G :USERID ,CANDIDATE_ID ETC )AS DIFFERENT COLUMNS one after another) where in BIP regular table is used because of which the ids are shown as Row wise( E.G ( USER_ID ,CANDIDATE_ID ) ITEMS AS SAME ONE COLUMN UNDER Identifier Type Column) for which in BIP the Rows are more then OTBI. Need to fix the
0