BI Components in Portal 

Use

The integration of BI Content into the portal ideally takes place using BEx Web applications and queries that run in the Web browser.

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

Features

Data Warehousing Workbench

The Data Warehousing 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 Data Warehousing Workbench in the Portal Content Studio as SAP Transaction iView.

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

●      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 the Data Warehousing Workbench is RSA1.

●      The GuiType property has to contain the value WinGui.

BEx Analyzer

The Analysis & Reporting: BEx Analyzer (BEx Analyzer) is an Excel add-in with extensive OLAP functionality in connection with a BI system. In order to use the BEx Analyzer, you have to have the SAP GUI for Windows with the BI 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 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 the BEx Analyzer is RRMX.

●      The GuiType property has to contain the value WinGui.

BEx Web Application Designer

The portal is an application that runs on the Web browser. 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 depends on the local installation directory. Single Sign-On is not supported.

BEx Query Designer

The portal is an application that runs on the Web browser. The Query Design: 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.

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 depends on the local installation directory. Single Sign-On is not supported.