Scenario 4: I need to publish reports where users can't modify the layout of the report

Scenario 4: I need to publish reports where users can't modify the layout of the report

Solution:

Publishing reports that have no BW functionality and no update capabilities allow you to distribute data across your company without changes to the numbers or content. This also allows you to distribute reports to non-BW users.

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 BW BEx toolbar, select the Tools icon > All queries in workbook > Detach.
5. A warning message will prompt you to accept the detachment.
6. The workbook is now severed from the BW system and OLAP functions are no longer applicable.
7. Using the Excel menu path, choose File > Save As...
8. Save the Excel Workbook to a local drive.
9. The report can now be distributed as an Excel attachment with no requirement for BW access.


CREATING HIGH IMPACT BW WORKBOOKS

 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 first published in August 2005