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

CASE Statement - Multiple rows in OTBI

edited Sep 13, 2018 4:09PM in Reporting and Analytics for HCM 6 comments

Content

Hi,

We have local legislative requirement for a report do deliver it in certain type of format.
As the information is stored differently in HCM Cloud e.g. Element Name Type and Displayed Input Value, we need to put information one per column for each element type as on following screenshot:

 

For that wanted to use following case statement:

CASE WHEN "Element"."Element Name"='XX:Personal Pay' THEN "Element Entry Value"."Displayed Input Value" ELSE NULL END

But it seems that this solution bring multiple rows with no values. Preview in attachement.
Any advice how to fix this to have this in one row?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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