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

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