Setting Up a Model Connection for the Entry and Approval Application

Use

You must create a special model connection for every model that you want to use in the Entry and Approval application.

The Entry and Approval application requires a model connection to Application Server that can read dimension member and measure names without restrictions. This step ensures that the Entry and Approval connection has access to all the information that is required. Users are connected to the model with the correct privileges and receive the full set of meta data. The model connection associated with the MMADMIN user has limited access to Interactive Publisher functions and features, which ensures a secure environment.

Prerequisites

The Application Server dimensional model is created. For information, see the Application Help for SAP Strategy Management on the SAP Help Portal at https://help.sap.com/viewer/p/SAP_STRATEGY_MANAGEMENT.
The Application Server dimensional model does not contain text variables.
The measures in the model have either monthly, quarterly, or yearly data. Entry and Approval does not support measures with any other periodicity.
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.
You are the administrator of strategy management.
You have set up client access to the SAP NetWeaver System database and created the ssm_cb_ea link ID in Application Server. For information, see Setting Up Client Access to the SAP NetWeaver System Database and Creating a Link ID for Certain Implementations.

Procedure

Start the administration application. Depending on the authentication set up at your site, you may be prompted to log on. If you are prompted, log on as the strategy management administrator. For more 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. You can specify any name for the model connection name. It does not need to match the dimensional model 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 Web Server 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 Web Server User 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 Entry and Approval.
In the PAS User text box, type MMADMIN. MMADMIN is a user that exists by default in MASTERDB. This user has special privileges to authorize dimensional models to be used for Entry and Approval.

Note This model connection must have only one client/server connection.
In the Password text box, do not type any 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. See the SUPERVISOR SHOW USERS command and SUPERVISOR CHANGE USER MAXLOGIN command for information about changing logins. For information, see the Application Server online Help in the Application Server Administrator program.
For Groups and Users, keep the default setting of allowing all users (Everyone) to use this model connection. Everyone who uses Entry and Approval must have access to the model. This is a limited-access model connection that gives users the ability to read measures and dimensions in the dimensional model.

Note Only one Application Server user can be assigned the Everyone setting for a model connection. If you try to create a second Application Server user with the Everyone setting, you receive a message telling you to pick specific users or groups.
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.
Repeat these steps for any other dimensional model you want to use in Entry and Approval. You must create separate model connections for scorecards and reports.