Q
Problem solve Get help with specific problems with your technologies, process and projects.

How to convert a BW report from BEx format to a WAD template

I have a problem when passing a portal user ID to a BW report. I am displaying the BW report not by WAD template but with a BEx query string. How do I convert the BEx format to a WAD template?

I have a problem when passing a portal user ID to a BW report. I am displaying the BW report not by WAD template but with this BEx query string:

/sap/bw/BEx?infocube=0IC_C03&query=0IC_C03_Q0009&sap-language=EN

There are about 300 reports that need to be integrated and I need to convert all the reports to a WAD template. Is it possible to pass my portal user ID along with a query string such as:

/sap/bw/BEx?infocube=0IC_C03&query=0IC_C03_Q0009&sap-language=EN&UserId=<User.LogonUid>

What you need to do is a 'Single Sign On' to BW. Then a user log-in to EP and then automatically to BW. Then you need to create roles for different user groups that you need, insert your queries to the correct role and assign that role to a user. Then you log in to EP and then to BW and as a result you will see the role you created and all reports within that role.

Dig Deeper on SAP Business Warehouse

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close