hahah i did it CAST(EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)',"Location"."Location Level 4",',',"Location"."Location Level 4") as CHAR(50))

so i found that using listagg you can get those multiple rows in a single row with comma separated value. i am trying to achieve that!! is that possible?

is their no other way? like use of evaluate aggr functions or so? i am new to OBI so not sure whether this will work

i wrote some logic which i found in the community but no luck since i am getting an error evaluate_aggr('sum(%1)', Location"."Location Level 4")

Hi All, Can you please share the link which I can refer to create a column repository at the backend. Basically as per your suggestions I can create a repository column at the backend which I can use in my reports, So if there is any link which is available Thanks a lot for your help so far Regards, Akshat

my version is 11.1.1.7.140225 i am learning obi after Microstrategy so excuse my silly questions what is RPD? is it column repository?

Hi Christian, My OBI version is 11.1.1.7.14 I don't see this option so is this related to security privileges? i guess i only have BI author credentials