You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

How to have Pivot in BIP based on a Logical SQL Pivot OTBI Report.

edited Oct 8, 2020 3:07PM in Reporting and Analytics for HCM 1 comment

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!