I'm trying to use the concat function in ether OTBI or BI to combine 4 fields. — Cloud Customer Connect
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

I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.

in Reporting and Analytics for HCM 9 comments

Summary:

I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center information which is 3 separate fields (enity.location.department) then adding the department name and the end. I'm using OTBI then dropping the SQL into a data model. Once i get past 2 strings it just doesn't want to work. I will list the fields in the content area along with the subject areas. Any insight into this will be greatly appreciated, this is the last piece of the puzzle for

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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