SAP Knowledge Base Article - Public

1684536 - Supported and Unsupported features of Xcelsius and Sap Netweaver BW connection

Symptom

Supported and Unsupported features of Xcelsius and Sap Netweaver BW connection

Environment

Client Details

  • Xcelsius Enterprise designer SP2(trial or engage server do not offer this connectivity)  or higher
  • Dashboard designer 4.0 all support packs and patches.
  • SAP GUI patch 901 or Higher.

Server Details

  • Sap Netweaver 7.0 EHP01 SP5 or higher(JAVA and ABAP stacks)

Important note:The BI java Stack and single sign on between ABAP and java are must to get this connectivity working.

Resolution

The new connection type for BW data offers a tighter integration of BW data into Xcelsius dashboards. The Xcelsius dashboard can be stored on the BW server and is integrated into the BW infrastructure, providing features such as transport, translation support .

BEx queries are used directly, as the communication between Xcelsius and the back end system is done via the same interface that is used for BEx Web layouts.

The following features are supported:

* (sub) totals defined in the query
* Calculated key figures
* Restricted key figures
* Exception aggregations
* Conditions
* Filters
* Variables
* Default values

 The following features are not supported so far:

* hierarchies
* exceptions
* input enabled queries
* Planning features
* interactive features know from the BEx front ends such as drill
down, swap axes etc.
* Embed the Dashaboard into Powerpoint, PDF, etc.
* Show the dashboard in preview mode

Limitations on systems and queries:


One dashboard can only be connected to one SAP NetWeaver BW system at a time. However, one
dashboard may have several connections to the same BW system, and combine data from different queries.

Performance considerations and hints:
A key feature of that connection type is that it allows you to retrieve both the query result and the list of values in a single execution. This greatly reduces the number of connections in your Xcelsius dashboard (e.g. providing master data for selector components).

The system will read query information on each connection defined at the initial load, whether the connection is to be refreshed or not. This has an impact on performance and it is recommended to have as few connections as possible defined in the dashboard.

Keywords

BICS Remote Web Service, Xcelsius, Dashboard Designer, SAP BW connection, requisites, limitations , KBA , BW-BEX-ET-XC , Please, use component BI-RA-XL. , How To

Product

SAP BusinessObjects Dashboards software 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008