Checklist

Scenario 3: I need my users to have the latest data available

In this scenario, it is critical for your business that only one - the latest - version of a report gets circulated.

Solution:

1. Launch the BEx Analyzer.
2. Using the Excel toolbar, open a previously saved workbook.
3. In order to have the most relevant data appear you want to make your workbook "auto-refresh".
4. In the results section of your report, right-click on any field and choose Properties.
5. Navigate to the Interaction tab.
6. Check 'Refresh query when opening workbook'. Click ok.
7. Using the BW BEx toolbar, select the Save icon > Save Existing workbook.
8. The next user to open this report will automatically receive the latest data from the BW database.


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: