Scenario 5: I have a requirement to put all my reports into a single package

So you've purchased and installed SAP BW at your company and you've created some basic reports. So far, so good -- but now it's time to take BW to the next level. This checklist provides you with proven project strategies that increase the use of your BW reporting. This is the fifth scenario.


The ability to create and share a reporting package allows simpler distribution and access to data.

1. Launch the BEx Analyzer.
2. Using the Excel toolbar, open a previously saved workbook.
3. Execute the report by clicking the Refresh icon if it does not automatically get refreshed.
4. Using the Excel menu path, choose Insert > Worksheet .
5. Click on the new worksheet to make it active.
6. Using the BW BEx toolbar, select the Tools icon > Insert query.
7. From the pop-up window, select a second query to embed into the new worksheet.
8. This second report will now be displayed on its own worksheet.
9. Repeat steps 4 through 8 to add additional queries to your workbook.
10. When finished, follow the steps outlined in Scenario 3 to ensure consistency.


 Home: Introduction
 Scenario 1: I need to create a customized template with my company's logo
 Scenario 2: I need to create a template without gridlines
 Scenario 3: I need my users to have the latest data available
 Scenario 4: I need to publish reports where users can't modify the layout of the report
  Scenario 5: I have a requirement to put all my reports into a single package
 Scenario 6: I want to lock the data values found in my BW reports
 Review: Conclusion and more resources
This was last published in August 2005

Dig Deeper on SAP business warehouse

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.