Components from SAP BW in the Enterprise Portal 

Use

The integration of SAP BW content into the Enterprise Portal ideally takes place using BEx Web applications and queries that run in the Web browser.

You can also integrate other BW components, such as the Administrator Workbench or the BEx tools BEx Query Designer, BEx Web Application Designer, or BEx Analyzer into the portal.

Features

Administrator Workbench

The Administrator Workbench is a comprehensive SAP transaction that functions only in connection with a locally-installed SAP GUI for Windows. With a SAP GUI for Windows 6.20 or higher, you do not have to logon again if you want to display SAP GUI for Windows transactions in a Web browser window (single sign-on is supported).

You can generate the Administrator Workbench in the Portal Content Studio as SAP Transaction iView.

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

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

·        The Transaction for the Administrator Workbench is RSA1.

·        The GuiType property has to contain the value WinGui.

BEx Analyzer

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

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

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

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

·        The Transaction for the BEx Analyzer is RRMX.

·        The GuiType property has to contain the value WinGui.

BEx Web Application Designer

The Enterprise Portal is an application that runs on the Web. The BEx Web Application Designer is a Windows application. It is technically possible to start Windows applications in the Web browser but this is not recommended for security reasons. Instead, you call the Windows application BEx Web Application Designer from the Windows start menu.

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

Note that the path is dependent on the local installation directory. Single sign-on is not supported.

BEx Query Designer

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

As an alternative to the BEx Query Designer, in a Web environment such as the Enterprise Portal, you can use the Ad-hoc Query Designer to create or change queries. You can insert the Ad-hoc Query Designer into a Web application and integrate it using the role upload, for example, or as an iView into the Enterprise Portal.

You can generate the BEx Query Designer in the Portal Content Studio as a URL iView. The most important property is the URL that contains the value file://C:/Program%20Files/SAP/FrontEnd/Bw/wdbrlog.exe .

Note that the path is dependent on the local installation directory. Single sign-on is not supported.

BEx Browser

The BEx Browser behaves like the BEx Web Application Designer or the BEx Query Designer.

There is little point in using the BW-specific BEx Browser in a company-wide Enterprise Portal because the basic functionality of the BEx Browser (calling reports) is covered in the Enterprise Portal.