BW Workbook as an iView in the Enterprise Portal 

Use

BW workbooks are MS Excel workbooks with one or more embedded BW queries. You are able to display these workbooks in the Enterprise Portal as iViews.

Features

Workbooks are displayed in a separate MS Excel window. Opening workbooks within the Web browser window is not possible for technical reasons.

BW workbooks require the BEx Analyzer, which requires a local installation of the SAP GUI for Windows with the BW front end.

SAP recommends that you use BEx Web applications in the Enterprise Portal that run completely in the Web browser.

You can use the function Export as Excel 2000 File from the BW Web application context menu as an alternative to using a local installation of the BW front end if you require Excel functions. See Context Menu Functions  and Exporting as a CSV File/Excel 2000 File.

An iView with a workbook can be generated using the Portal Content Studio or Role Upload. For more information, see Generating Content from SAP BW for the Enterprise Portal.

The iViews are of type SAP Transaction iView and have the code link com.sap.portal.appintegrator.sap.Transaction.

The most important properties are System, Transaction (TCODE) and ApplicationParameter.

·        The System property contains the alias on the BW system (see Creating BW Systems in the  Portal).

·        The transaction code for every workbook is RRMXP.

·        The value WBID=<WORKBOOK_ID> is in the ApplicationParameter property.

You can determine the workbook ID with the BEx Analyzer:

                            a.      Open the desired workbook.

                            b.      In the BEx toolbar, choose ® OLAP Functions for Active Cells ® Properties. The Information tab page contains the Workbook ID (Server).

Note that with BW workbooks as an iView, the AutoStart property contains the value True (process first screen) and the GuiType property contains the value WinGui.

For more information about other iView properties, see iView Properties.