BEx Web Application or Query as iView in the Enterprise Portal (SAP Library

BEx Web Application or Query as iView in the Enterprise Portal

Use

BEx Web applications and queries that are being displayed in the Web with the Standard Web Template for Ad-hoc Analysis can be displayed as iViews in the Enterprise Portal.

Note

BEx Web Applications are executed Web templates that are created using the BEx Web Application Designer. If BEx Web Applications are being used in both the portal and without the portal, it can make sense to only display specific functions (for example, Enhancements to the Context Menu with JavaScript or specific manipulations of cell contents using the Web Design API for Tables within the portal.

The JavaScript function SAPBWGetProperty returns the Web template property RUNS_AS_IVIEW. If you use the Web Design API for tables, you can query the parameter SAPWP_ACTIVE in the Attribute N_R_CREATION_PARAMETERS. The property RUNS_AS_IVIEW and/or the parameter SAPWP_ACTIVE display whether a BEx Web Application is running in the portal at runtime or not.

Features

A BEx Web application or query as an iView can, together with other iViews, be part of a portal page or can take up the complete content area. A direct call of the BEx Web application or query takes place in the BW system, with which the current data is displayed. When using the portal cache, data updates can appear with a delay. For more information on setting up the portal cache, see Integration Using the Portal Content Studio.

An iView with a BEx Web application can be generated using the BEx Web Application Designer, BEx Query Designer or Portal Content Studio. For more information, see Creating Content from SAP BW for the Enterprise Portals.

The iViews are type SAP BW Report iView and have the code link com.sap.portal.appintegrator.sap.BWReport.

The two most important properties, System and Report (or BEx Web Application Query String) are automatically set on the BEx Web Application Designer and BEx Query Designer. You need to enter these properties manually in the Portal Content Studio.

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

· The report or BEx Web Application Query String property has to include the following values for BEx Web applications, BW queries or BW bookmarks:

¡ BEx Web application: template_id=<TEMPLATE_ID>

¡ BW query: infocube=<INFOCUBE>&query=<QUERY>

¡ BW bookmark: bookmark_id=<BOOKMARK_ID>

Note

You are able to add further URL parameters of SAP BW to the Report or BEx Web Application Query String property, for example to set filter values. The URL parameters are separated by an ampersand &. For more information, see Command URLs and Call Web Template.

For more information about other iView properties, see Structure link iView Properties.