BEx Tools and BW Tools in the Portal

Integration of content from BEx into the portal should ideally take place using BEx Web applications and queries that run in the Web browser.

You can also integrate other BW components into the portal, such as the Data Warehousing Workbench or the various BEx tools (BEx Analyzer, BEx Query Designer, BEx Report Designer or BEx Web Application Designer).

BEx Analyzer

Business Explorer Analyzer (BEx Analyzer) is an Excel add-in with extensive OLAP functionality in connection with a BW system. In order to use BEx Analyzer, you need the SAP GUI for Windows with the BW Front end installed locally. For technical reasons, BEx Analyzer opens in a separate window. As Single Sign-On is supported, you do not have to log on again. A SAP GUI for Windows appears in the work area in the portal window.

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>

Calling via a Transaction

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

The most important properties are System, Transaction(TCODE), and GuiType:

• The System property contains the alias for the BW system (see Automatically Configuring BI Java ).
• The transaction for BEx Analyzer is RRMX.
• Property GuiType must contain value WinGui.

BEx Query Designer

The portal is an application that runs in a Web browser. BEx Query Designer is a Windows application. It is technically possible to start Windows applications in a Web browser, but this is not recommended for security reasons. You should call the Windows application BEx Query Designer from the Windows start menu.

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

You can open BEx Query Designer either without a query, for example to create a new query, or with a query that you want to edit.

• Parameter to start BEx Query Designer (without query): ?TOOL=QD
• Parameter to start BEx Query Designer with query: ?TOOL=QD_EDIT&QUERY=<query_id>

BEx Report Designer

The portal is an application that runs in a Web browser. BEx Report Designer is a Windows application. It is technically possible to start Windows applications in a Web browser, but this is not recommended for security reasons. You should call the Windows application BEx Report Designer from the Windows start menu.

You can call BEx Report Designer by entering the following URL in the portal:

http(s)://<server:port>/sap/bc/bsp/sap/rsr_bex_launch/bexanalyzerportalwrapper.htm/?TOOL=RD

BEx Web Application Designer

The portal is an application that runs in a Web browser. BEx Web Application Designer is a Windows application. It is technically possible to start Windows applications in a Web browser, but this is not recommended for security reasons. BEx Web Application Designer is a Windows application. You should call it from the Windows start menu.

You can generate BEx Web Application Designer in the Portal Content Studio as a URLiView.The most important property is the URL containing file://C:/Program%20Files/SAP/FrontEnd/Bw/wdbpwpub.exe.

Note that the path depends on the local installation directory. Single Sign-On is not supported.

Data Warehousing Workbench

Data Warehousing Workbench is a comprehensive SAP transaction that functions only in connection with a locally-installed SAP GUI for Windows. With version 6.20 or higher of SAP GUI for Windows, you do not have to log on again if you want to display SAP GUI for Windows transactions in a Web browser window (Single Sign-On is supported).

You can generate Data Warehousing Workbench in the Portal Content Studio as an SAPTransactioniView.

The most important properties are System, Transaction(TCODE), and GuiType:

• The System property contains the alias for the BW system (see Automatically Configuring BI Java ).
• The Transaction Code for Data Warehousing Workbench is RSA1.
• Property GuiType must contain value WinGui.