BW Bex 3.x Macros to create Formatted Workbooks – Part 2

There are 2 basic files that are needed to run the sample file with Macros.
A. BW Macro Addin [SAPTECHEDBIM301_DEMO_VA1.1.xla]
B. Sample BW Workbook with a query. [SAPTECHEDBIM310_DEMO_ADDIN_V1.3.xls]

Steps to setup an offline demo of BW BEX Macros.

1. Download the xla file from here to a local folder in your pc/laptop.

2. Download the xls file from here to the same local folder in your pc/laptop.

If you have problems in downloading the files, click here to download the zip file. Note : The above example works only with Excel 2003 in Windows XP.

3. After downloading both the files, double click on the xla file. This is the BW Macro Addin which enables creating formatted workbooks. Following message shown in the picture pops up, click on “Enable” .

4. Double click on the xls to open the sample workbook that has a SAP BW Query into it.

5. You would see a sample BEx Report embedded in the workbook. The workbook contains a tab named “BWMacros”.
6. The BW BEx Toolbar must be visible {Toolbar with four buttons} If not it can be enabled by doing a right click on the top section of the excel as shown in the picture.

7. After enabling the BW Macros you mush be able to see the toolbar with 4 buttons.

8. The sample workbook has following sections

Report header
Navigational Block
Filter Block
Result area.

9. Click “Navigation” button in the BW Macro Toolbar to hide the navigational block.

10. Click “Filter” button in the BW Macro Toolbar to hide the filter block

11. Click on “Format” button to create 2 additoinal sheets automatically. The sheets are created after the main tab “BWMacros”. The tabs are named “BWMacrosFormat” & “BWMacrosPrint” as shown in the figure.

12. The “BWMacrosPrint” tab is protected from changes and is mainly for printing. The print settings are set automatically based on the report output.

13. Go to “BWMacrosFormat” tab and maintain all the formatting such as changing font, color, adding rows, columns, calculations etc.

14. Once the formats are done, click the refresh button in the BW Macros tool bar to carry on the formatting from the Format sheet to the Print sheet.

15. To see what happens when the data changes, try to change some data in BWMacros tab which is nothing but the bw query data.

16. Press “Refresh” button from the toolbar to see the data getting reflected in the “BWMacrosPrint” tab.

Note : Do not change the tab name as this is only the demo version. In case if you are stuck and want further assistance, you can reach me at dinaish@gmail.com or dinaish@yahoo.com.