BEx Analyzer Workbook as an iView in the PortalUse

Workbooks are displayed in a separate Microsoft Excel window. Das Öffnen von Arbeitsmappen innerhalb des Web-Browser-Fensters ist aus technischen Gründen nicht möglich.

BEx Analyzer workbooks need BEx Analyzer. This makes it necessary to have a local installation of SAP GUI for Windows with the BW front end.

We recommend using BEx Web applications that run entirely 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 BW front end if you need to use the functions of Excel. More information: Context Menu Functions and Exporting as CSV File/Excel File .

An iView with a workbook can be generated using the Portal Content Studio or Role Upload. More information: Generating BEx Objects and BW Objects for the Portal .

To call BEx Analyzer in the portal, you have the following options:

Call via a URL

You can call BEx Analyzer with the following URL: http(s)://<server:port>/sap/bc/bsp/sap/rsr_bex_launch/bexanalyzerportalwrapper.htm

You can modify the URL to open BEx Analyzer with either a workbook, a query or a query view. You can use the following parameters to do this:

• Parameter to open the workbook: ?WBID=<wb_id>
• Parameter to open the query: ?QUERY=<query_id>
• Parameter to open the query view: ?QUERY_VIEW=<queryview_id>
  Note

  We recommend calling the tool via the URL instead of calling via the transaction.

  Note

  If you want to call BEx Analyzer outside the portal, you can use the following URL: http(s)://<server:port>/sap/bc/bsp/sap/rsr_bex_launch/bexanalyzer.bex

Calling via a Transaction

You can generate BEx Analyzer in Portal Content Studio as an SAP Transaction iView.

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 contains the alias for the BW system (see Automatically Configuring BI Java ).
• The Transaction Code for all workbooks is RRMXP.
• The ApplicationParameter property contains the value WBID=<WORKBOOK_ID>.
  Note

  You can find out the workbook ID using BEx Analyzer:

  1. Open the required workbook.
  2. In the BEx Analyzer design toolbar, choose Workbook Settings The Workbook Settings dialog contains the workbook ID in the Name of Workbookfield.

     More information: Specifying Settings for Workbooks

When using BEx Analyzer workbooks as an iView, note that the AutoStart property contains the value True(process first screen)and the GuiTypeproperty contains the value WinGui.

More information: iView Properties .