Setting Up a Model Connection

Use

This section contains required steps for all installations. Follow the steps in this section to create your first model connection. Model connections connect Web authentication users to Application Server users to a model and ultimately to a scorecard context.

For information about creating model connections, see the application help for SAP Strategy Management on the SAP Help Portal at https://help.sap.com/viewer/p/SAP_STRATEGY_MANAGEMENT. Choose Start of the navigation path Administration Next navigation step Administration Model Connection Development End of the navigation path .

Prerequisites

The Application Server dimensional model is created. For information, see the SAP Strategy Management Application Server Help on the SAP Help Portal at https://help.sap.com/viewer/p/SAP_STRATEGY_MANAGEMENT. If you do not have a model created, you can use the sample model provided with the Application Server installation.
The Application Server dimensional model in the strategy management application does not contain text variables.
The machine where the administration application is installed has access rights to the port where Application Server is installed. If you can telnet <hostname> 8325 from a DOS window, then you have the appropriate access rights.

Procedure

Start the administration application. For information, see Starting the Administration Application.
Choose Administration Manage Models.
Select New in the Model Connections list. The Model Connection text box appears in the Connection Settings section.
In the Model Connection text box, type a model connection name. Specify only alphanumeric characters (a-z, 0-9) up to a maximum size of 64 characters. You must not use special characters in the name. Then click OK.
In the PAS System Name text box, type the name of the server where Application Server is located. If Interactive Publisher is installed on a different server than SAP NetWeaver, then enter the IP address for Application Server.
In the PAS System Logon text box, type the authentication name of a user on the Application Server system. On Windows, this user must be a member of the administrators group. On Linux/UNIX, this user must have permission to run the scripts and programs in the Application Server installation directory.
In the Password text box, type the password for the Web authentication user.
In the PAS Model text box, type the name of the Application Server dimensional model to use for this model connection.
In the PAS User text box, type the Application Server user who has access to the Application Server model who you want to add to this model connection.

Note Make sure the Application Server user is a user of the dimensional model you are adding to the model connection definition.

Note If you are running Application Server on a Linux/UNIX server, the UNIX or Linux user specified in the PAS User text box must have appropriate access to the $ORACLE_HOME directories, particularly $ORACLE_HOME/lib32. It is highly recommended to grant read and execute access to the directory structure under $ORACLE_HOME to ensure that there are no problems with Application Server connections to Oracle. You can run the $ORACLE_HOME/install/changePerm.sh script to ensure that the account used for client/server connections has the appropriate access privileges to the Oracle client software. This script establishes Read access to most of the directories in $ORACLE_HOME.
In the Password text box, type the password for the Application Server user. If the user is Guest, you do not need to specify a password.
In the Port text box, type the communications port for the UNIX or Windows server machine running Application Server. The default is 8325.
In the INI file text box, type the name of the Application Server initialization file to use. The default filename created at installation is lsserver.ini.
In the Service text box, type the service parameter specified in the lsserver.ini file. The default service name is PILOT.
In the Min Instances text box, type the number of copies of Application Server to start up with this model connection. The default setting is 0, which means that no copies start until the first URL query is submitted.
In the Max Instances text box, type the maximum number of copies of Application Server to allow for this model connection. The default setting is 5. You can set up to 255 instances.

Note
You must specify a number of Application Server instances that is equal to or lower than the number defined for the Application Server user. For example, if the Application Server user is allowed 5 instances, enter a number up to 5.

To find out the maximum number of instances available to an Application Server user, issue the SUPERVISOR SHOW USERS command in Application Server. To change the number of instances available to an Application Server user, issue the SUPERVISOR CHANGE USER command with the MAXLOGIN keyword. See the Application Server Administrator's Guide on the SAP Help Portal at https://help.sap.com/viewer/p/SAP_STRATEGY_MANAGEMENT.
Click Test Connection. You see messages that the Application Server connection is made, you are logged in, and the USE database is found. Click OK to close the message box.
Click Save.
At the confirmation message, click OK.
In the Groups and Users section, Everyone is the default selection. This means that all users are added to the model connection by default. Since you have not populated the user lists yet, only the user designated as the strategy management administrator is a user at this time.