To define a system connection to SAP BusinessObjects Business Intelligence

Context

The BOESystems setting allows you to define system connections to the business intelligence platform. It is maintained in the file Ao_app.config that is stored in the file system under C:\ProgramData\SAP\Cof.

As administrator, you can define the setting and you can also define if a user should be able to change a setting locally.

As a user, you can change the setting in the file system under Users\<UserID>\AppData\Roaming\SAP\Cof. The file name for changing the settings locally is ao_user_roaming.config.

Users can select the defined system connections from the Web Service URLs list in the Logon to SAP BusinessObjects Enterprise dialog box when opening or saving workbooks.

Procedure

Navigate to the folder C:\ProgramData\SAP\Cof and open the file to change the setting.

Define the system connections in setting BOESystems.

Example with defined connections to three platform servers:

<BOESystems>
<![CDATA[<?xml version="1.0" encoding="utf-16"?>
<ArrayOfCoBoeSystemInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns:xsd="http://www.w3.org/2001/XMLSchema"/>]]>

<CoBoeSystemInfo>
<SystemId>vm2468</SystemId>
<Hostname>vm2468</Hostname>
<Scheme>http</Scheme>
<Port>8080</Port>
<SessionServiceUrl>/dswsbobje/services/Session</SessionServiceUrl>
<Active>true</Active>
<UseSso>false</UseSso>
<LastUsedAuthentication>secEnterprise</LastUsedAuthentication>
<CMSNames><string/></CMSNames></CoBoeSystemInfo>

<CoBoeSystemInfo>
<SystemId>vm1357</SystemId>
<Hostname>vm1357</Hostname>
<Scheme>http</Scheme>
<Port>8080</Port>
<SessionServiceUrl>/dswsbobje/services/Session</SessionServiceUrl>
<Active>false</Active>
<UseSso>false</UseSso>
<LastUsedAuthentication>secEnterprise</LastUsedAuthentication>
<CMSNames><string/></CMSNames></CoBoeSystemInfo>

<CoBoeSystemInfo>
<SystemId>vml2145</SystemId>
<Hostname>vml2145</Hostname>
<Scheme>http</Scheme>
<Port>8080</Port>
<SessionServiceUrl>/dswsbobje/services/Session</SessionServiceUrl>
<Active>false</Active>
<UseSso>false</UseSso>
<LastUsedAuthentication>secEnterprise</LastUsedAuthentication>
<CMSNames><string/></CMSNames<</CoBoeSystemInfo>


</ArrayOfCoBoeSystemInfo>
 ]]>f(clean);
 </BOESystems>

Enter the required value for the parameter SystemId.
As Hostname, enter the name of the machine that the business intelligence platform is installed on.
For the parameters Scheme, Port and SessionServiceUrl, enter the URL values that were defined during the installation of the business intelligence platform.
To set this connection to the business intelligence platform as the default connection, enter True for the Active parameter.
If you enter False for the Active parameter the connection appears as an entry that can be selected by the users in the list of connections in the logon dialog box.
For the parameter UseSso, you can specify if the SSO check box in the log-on dialog is checked or not. The value changes if the user selects or deselects the check box.
For the parameter LastUsedAuthentication, you can enter an authentication type that is used in the log-on dialog.
For the parameter CMSNames, you can enter a system to specify the central management system for the log-on dialog.

Save the file with the defined setting.

Results

The Logon to SAP BusinessObjects Enterprise dialog box contains the list with the three configured Web Service URLs that describe the connections to the business intelligence platform servers. The first entry in the settings file is the default connection.

Users can define additional connections to business intelligence platform servers in the logon dialog box. For more information, see the User Guide: SAP BusinessObjects Analysis, edition for Microsoft Office at http://help.sap.com.

Note After creating a new connection in the Logon to SAP BusinessObjects Enterprise dialog box and logging on to this business intelligence platform server, Analysis adds this connection to the BOESystems setting and sets it as the default connection. If there is already data from this business intelligence platform server in the BOESystems setting, Analysis changes the diverging parameter values in the BOESystems setting and sets this connection as the default.