- Community Home
- >
- Welcome
- >
- Other HPE Product Questions
- >
- SAP BI SQL Query to display rows as columns
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-18-2018 08:11 AM
01-18-2018 08:11 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2018 04:46 PM
01-20-2018 04:46 PM
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