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.
This was last published in June 2007

Dig Deeper on SAP business warehouse

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close