Former HPE Products
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BI SQL Query to display rows as columns

 
Paul Singh
Advisor

SAP BI SQL Query to display rows as columns

Hello,

I am trying to create an OMi event report in OBR using WebIntelligence. We have 10 different custom slots. For a given event, I want to display those custom slots as columns. We have CustAtt and CustAttVal. CustAtt should apprear as column name, and CustAttVal should be the corresponding value for its related CustAtt. Is there any SAP BOBJ BI SQL funciton I can use to acheive this? I tried STRING_AGG, but I get an error message that function does not exist, or the permissions do not exist.

Currently it appears as this

DateCreated, Title_Text, Sev, CustAtt, CustAttVal
2017/12/13, TestAlert1, Major, AppName, App1
2017/12/13, TestAlert1, Major, TktNum, Ticket1
2017/12/14, TestAlert2, Minor, AppName, App2
2017/12/14, TestAlert2, Minor, TktNum, Ticket2

This is how it should be displayed

DateCreated, Title_Text, Sev, AppName, TktNum
2017/12/13, TestAlert1, Major, App1, Ticket1
2017/12/14, TestAlert2, Minor, App2, Ticket2

Thanks.

 

1 REPLY 1
Dennis Handly
Acclaimed Contributor

Re: MF OMi SAP BI SQL Query to display rows as columns

This is the wrong company for MF software questions. You need to register in the MF Software Forum:
https://community.softwaregrp.com/t5/Operations-Manager-i/bd-p/operations-manager-i-practitioners