3 Replies Latest reply: Nov 2, 2016 3:05 AM by MARCO HADIYANTO RSS

    Merge dims on multiple rows on single row in straight table

    Aravind Sasidharan

      Hi,

       

      I am having a bit of trouble merging multiple attributes linked to a fact table into a single row. Any help would be greatly appreciated  

       

      Here is the data model.

       

      dm.png

      There are multiple roles/people associated with every project. Some of these people are internal users and others are external users.

       

      This is the desired o/p

      op.png

      For every project we want to merge the multiple roles into a single row in a straight table.

       

      I tried playing around with  Aggr() function e.g. Aggr(MaxString({<ROLE={'Client'}>} ORG_NAME), ORG_NAME)

      but it doesn't work when all the fields are added. I am definitely missing something but don't know how to proceed.

       

      The sample app is attached. Can someone please suggest a possible approach?

       

      Thanks in advance!