This how-to guide explains how to create BI System connection in the SAP Netweaver Portal System Landscape.
Applicable for: PBF 8.0 (SAP Netweaver Portal 730)
This information is derived from the SAP Help document for this BI System Connection guide, which you can find here:http://help.sap.com/saphelp_nwce72/helpdata/en/48/a80b71516b35b6e10000000a42189d/content.htm.
- Log on to the portal at http://<host>:<port>/irj using the administrator user.
- Choose System Administration System Configuration System Landscape . Refer to Figure 1.
Figure 1 – Navigating to System Landscape
For more information on help.sap.com, see Creating Systems.
- In the context menu (right click) for Portal Content, choose Content New System (from template) . Refer to Figure 2.
Figure 2 – Creating a New System
- Choose the SAP system with load balancing template.
- Enter the System Name, System ID, System ID Prefix, and Description and click Next. Refer to Figure 3.
Figure 3 – System Properties
- Create an alias named PBF_BI and set it to default. Refer to Figure 4.
Note: It is important that the alias is named exactly PBF_BI. PBF Budget Forms are designed to use the PBF_BI system alias and if they fail to find such an alias, they will return error messages.
Figure 4 – Aliases
- Click Finish.
- Maintain the properties in the following categories by selecting the newly created system and going in edit/modify mode. Refer to Figure 5.
- BI/Business Intelligence
- BI Directory Provider: yes
- BI Master System: yes
Figure 5 – BI Settings
- Connector. Refer to Figure 6.
- Group: Logon group of the back-end system. Logon group can be found or maintained via transaction SMLG. Ask Basis Administrator if unsure of this parameter setting.
- Logical System Name: Logical system name of your back-end system. SAP recommends the format <SAP System ID>CLNT<Client>. For example, if your SID is PBF and your client is 200, then your Logical system name would be PBFCLNT200.
- Message Server: Message server of the back-end system. This parameter can be found using transaction SMICM by navigating to Goto > Parameters > Display. Scroll to the end for Misc settings and check the icm/host_name_full. Alternatively this can also be found using properties of SAP GUI log on pad.
- Remote Host Type: Set this to 3 (For R/3 system).
- SAP Client: Client of the back-end system.
- SAP System ID: System ID (SID) of the back-end system.
- Server Port: Set this to variable sapms<SID> and the actual port will be automatically resolved.
- System Type: SAP_BW.
Figure 6 – Connector Settings
You can also find the values for the logon group, system ID, and message server from the properties in the SAPGUI log on for the BI back-end system.
- User Management. Refer to Figure 7.
- Authentication Ticket Type: SAP Assertion Ticket (click All Properties if you are on the basic view).
- Logon Method: SAPLOGONTICKET is recommended. If you are using UIDPWD method then you have to maintain mapping for individual users in the User Administration settings of your Portal.
- User Mapping Type: admin, user.
Figure 7 – User Management
- After setting up the BW System, run the System Connection Tests for Connectors. Refer to Figure 8.
Figure 8 – System Connection Tests
If you see any errors on this screen start with verifying all of the settings entered while creating this system connection.
If you do not use the default alias as PBF_BI you will notice several error messages on PBF Budget Form screens when you try to open Expense, Revenue or Position tabs.
Also ensure that users with exact same login name exist in the front-end CE system and the back-end BW system as SSO will look for exactly same users to establish a connection.