Excelcius Web Server Error while connecting bpc

Error: You are trying to connect to web server while creating EPM connection from xcelcius through EPM Connector

Solution:  

This is due to incorrect configuration made at bpc netweaver webserver. 

You need to change following config files so that it can work. You need to install Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update installer.

For security reasons and after installing the components, the Planning and Consolidation Web server

administrator must modify the web.config file.

1. Go to the osoft virtual directory and open the web.config file for editing.

2. In the <system.web>, <webService>, <protocols> section of the file, comment out or delete the

following tag: <remove name="Documentation"/>.

3. Save and close the file.

Configure Xcelsius

To improve the stability of SAP BusinessObjects Extended Analytics Analyzer when embedded in

Xcelsius 2008, we strongly recommend enabling Live Office Compatibility in the Xcelsius 2008 preferences.

To enable Live Office Compatibility:

1. In Xcelsius 2008, select File Preferences .

2. On the left of the dialog box, select Excel Options.

3. In the Live Office Compatibility area, select the Enable option.

4. Click Apply.

5. Click OK.

Using Xcelsius with Planning and Consolidation & Configuring Xcelsius

Configure XMLA Provider

The XMLA Provider requires the following configuration settings:

1. On the Planning and Consolidation .NET server, go to <drive>/Websrvr/XMLA/ and open the

datasource.xml file.

2. In this file, update the server name to be the same as the Planning and Consolidation server

name in the same node:

<URL>http://<servername:port>/XMLA/XmlaWebService.asmx</URL>

<DataSourceInfo>Data Source = http://<servername:port></DataSourceInfo>

3. If this is not the case, do the following:

Change the file so that the server names are the same.

Save the file datasource.xml.

Restart the .NET server.