BEx Analyzer Workbook as an iView in the Portal 

Use

BEx workbooks are Microsoft Excel workbooks with one or more embedded BEx queries. You can display workbooks in the portal as iViews. You can also open BEx queries in the BEx Analyzer as an iView.

Features

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

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

We recommend that you use BEx Web applications in the portal that run completely in the Web browser.

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

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

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

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

●      The System property includes the alias on the BI system (see SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver → Business Intelligence → Settings for Reporting and Analysis  → BEx Web → Integration into the Portal → Create BI System 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 required workbook.

                            b.      In the design toolbar for the BEx Analyzer, choose Workbook Settings The dialog Workbook Settings includes the workbook ID in the upper field Name of Workbook.

●      The property ApplicationParameter has the value QUERY=<QUERY>, where <QUERY> is the technical name of the query.

If a workbook or query is not defined, the BEx Analyzer is started with a connection to the BI system only. An additional logon is not required.

The following properties must be defined in the iView in order to ensure a concrete start of the workbook or query in the BEx Analyzer.

●      The property AutoStart must have the value True.

●      The property GuiType must have the value WinGui.

●      The property Technique must have the value SAP Shortcut.

More information on other iView properties: iView Properties.