Integration of BW Components into the Portal 

Use

The integration of BW contents into the Enterprise Portal ideally takes place using Web applications and queries that run in the Web browser. In some circumstances, 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

Calling the 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, you do not have to log on again if you want to display SAP GUI for Windows transactions on the Web (single sign-on is supported).

You can generate the Administrator Workbench in the portal as an external service either using SAP role migration or manually by way of the following steps:

...

Start the External Service wizard from Content Admin/Roles/Edit Area/External Service and choose Create.

Select the BW system.

Choose SAP Transaction as the application type.

Choose WinGUI as the GUI type.

As the transaction code, enter RSA1.

You can now assign the External Service to a role.

Calling the Business Explorer 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 Frontend 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 Enterprise Portal window in the work area.

You can generate the Administrator Workbench in the portal as an external service either using SAP role migration or manually by way of the following steps:

...

Start the External Service wizard from Content Admin/Roles/Edit Area/External Service and choose Create.

Select the BW system.

Choose SAP Transaction as the application type.

Choose WinGUI as the GUI type.

As the transaction code, enter RRMX.

You can now assign the External Service to a role.

Calling BW Workbooks

BW workbooks are MS Excel workbooks with one or more embedded queries. BW workbooks need the BEx Analyzer, which requires a local installation of the SAP GUI for Windows with the BW Frontend.

The Enterprise Portal is an application that runs on the Web. BW workbooks are suitable for Windows with Excel.

We recommend that you use BEx Web applications in the Enterprise Portal that also run completely in the Web browser.

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

SAP role migration automatically generates external services that point to BW workbooks. HERE AND CHECK PATHS

...

Start the External Service wizard from Content Admin/Roles/Edit Area/External Service and choose Create.

Select the BW system.

Choose SAP Transaction as the application type.

Choose WinGUI as the GUI type.

As the transaction code, enter RRMXP.

Choose Finish to save the external service.

You then have to add the following parameters using Edit since you cannot enter these using the wizard.

The parameter Additional Dynpro Parameters name-value-pairs (n1=v1;n2=v2;... – optional allows the workbook ID to be specified (for example “WBID=CN24XRCKJ8HDDIZ3CCUTGPF1A”).

Under Process first screen automatically?, enter the value True.

You can now assign the External Service to a role.

Calling the Business Explorer 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.

If necessary, you can create an HTML page on a Web server that contains the link 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.

Calling the Business Explorer 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 BEx 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 migration, for example, or as an iView into the Enterprise Portal. For more information, see Functions of the Ad-hoc Query Designer.

If necessary, you can create an HTML page on a Web server that contains the link 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.

Calling the Business Explorer 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.

 

You can find additional information in the Enterprise Portal documentation in the SAP Help Portal (http://help.sap.com) ® SAP NetWeaver ® SAP Enterprise Portal ® EP 5.0 SP5 ® Administration Guide ® Roles ®

·        Roles and SAP Systems ® Migration of SAP Roles to the Enterprise Portal

·        Role Maintenance ® Definition and Provision of Role Contents ® Creating External Services ® Creating External Services for SAP Transactions.

·        Role Maintenance ® Creating Roles and Assigning Contents ® Assignment of Content Objects to Roles ® Assigning External Services.