Checklist

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: