Convert Rows to Columns in OTBI from multiple subject areas

Summary:

Hi All,

We recently went live with oracle HCM implementation. I have a OTBI report requirement where I need to convert fields containing multiple rows to separate column values from multiple subject areas.

I utilized case when statement on "Workforce Management - Worker Assignment Real Time"."Seniority Date Setup" to build separate columns on date values and it worked fine.

But when I try to do this again in the same report on “Payroll – Element Entries real time” subject area to pivot “Element Name’ so as to get variable compensation fields (Total Target Variable and Total Target Comp), I am getting blank for these fields.