Scenario 2: I need to create a template without gridlines

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 second scenario.

Solution:

1. Launch the BEx Analyzer.
2. Using the Excel toolbar, open your previously saved template.
3. Follow the Excel menu path and choose Tools > Options > View. Remove the checkbox for Gridlines.
4. Using the BW BEx toolbar, select the Save icon > Save Existing workbook.
5. Open a BW Query into the BEx Analyzer and your template will appear without gridlines.




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

Dig Deeper on SAP business warehouse

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