SAP Netweaver Business Intelligence BI / BW

Symptom

When embedding a BEx Query via the SAP NW BI Connection you receive the error message 2032 immediatly after the BEx query selection dialog.
Please note that this is only relevant during Xcelsius design time and not during launching of the Xcelsius Dashboard (runtime).

Other terms

Xcelsius Design Time, Federated Portal Network, Error 2032, FPN,

Reason and Prerequisites

Prerequisite:
1. The landscape is configured as federated portal network. Details can be found in the SAP help portal:
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/5b/9f2d4293825333e10000000a155106/frameset.htm
2. The default portal maintained in table RSPOR_T_PORTAL references the consumer portal. See SAP note 1149597 for more details.
The reason for the error 2032: Xcelsius receives the URL to the consumer portal as it is the default portal. When trying to invoke the Web Service to retrieve the BEx Query meta data the web service execution fails.

Solution

The NetWeaver BW system used for Xcelsius Dashboard design must return the URL to the producer portal. This can be achieved by following one of the options:
1. Elaborate reason for chosing the consumer portal as default portal. Example: in case it is a development system the producer portal might be allow to be called directly.
2. The default portal can be set per user. Set the producer portal as default portal for all users involved in creating and maintaining Xcelsius Dashboards.
3. The default portal can be set per user. Create a special user for maintaing and creating Xcelsius Dashboard with the producer as default.
A detailed description for setting the default portal per user is available here:
http://help.sap.com/saphelp_nw70ehp1/helpdata/de/45/fe8e3066bc3482e10000000a1553f6/frameset.htm