Maintaining BI System Connections

Use

To use BI queries, query views, and InfoProviders as data sources for your models, you must first maintain a BI system connection in the Portal of a CE system.

 

Procedure

Exporting the J2EE Certificate

...

       1.      Log on to the J2EE start page at http://<host>:<port>.

       2.      Choose SAP NetWeaver Administrator.

       3.      Log on with an administrator user.

       4.      Choose Configuration Management -> Security Management -> Key Storage.

       5.      Click Edit.

       6.      Choose TicketKeyStore.

       7.      Choose SAPLogonTicketKeypair-cert

       8.      Click Export Entry.

       9.      Choose the export format Binary X.509.

   10.      Download the file.

 

Importing the J2EE Certificate into the BI Back-End System

       1.      Call transaction STRUSTSS02.

       2.      Place the cursor over System PSE.

       3.      Choose Certificate -> Import.

       4.      Specify the file system location of the J2EE certificate that you previously exported and confirm.

       5.      Click Add to Certificate List.

       6.      Click Add to ACL.

       7.      Specify the system ID of the J2EE Engine and client 000.

You can find the system ID (SID) of the portal on the start page of the J2EE Engine at http://<host>:<port>. Choose System Information and log on with the administrator user. The SID is displayed in the header.

       8.      In the context menu for System PSE, choose Distribute.

       9.      Save your entries.

 

Creating BI Users in the Portal

Ensure that the BI back-end users also exist in the J2EE Engine. You can use the BI back end as the user store for the J2EE Engine or you can create the users manually. If you create the users manually, you should ensure that they have the same names as in the BI back-end; this avoids the need to configure user assignment.

 

Creating the BI System Connection in the Portal System Landscape

       1.      Log on to the portal using the administrator user: http://<host>:<port>/irj

       2.      Choose System Administration -> System Configuration -> System Landscape.

For more information, see Running the System Landscape Wizard.

       3.      In the context menu for Portal Content, choose Content New -> System (from template).

       4.      Choose the SAP system with load balancing template.

       5.      Enter the system name, system ID, system ID prefix, and description and click Finish.

       6.      Maintain the properties in the following categories:

○       BI/Business Intelligence

■       BI Directory Provider: yes

■       BI Master System: yes

One of the connected BI systems has to be the BI master system. If you are only connecting one BI system, choose Yes. If you are connecting more than one BI system, choose Yes for one system and No for the remaining system.

○       Connector

■       Group: Logon group of back-end system

■       Message Server: Message server of back-end system     

■       Remote Host Type: 3    

■       SAP Client: Client of back-end system

■       SAP System ID (SID): System ID of back-end system

■       System Type: SAP_BW

You can find the values for the logon group, system ID, and message server from the properties in the SAPGUI logon for the BI back-end system.

○       User Management

■       Authentication Ticket Type: SAP Assertion Ticket

■       Logon Method: SAPLOGONTICKET

■       User Mapping Type: admin, user

       7.      Create a system alias.

 

Testing the Connection

Choose Connection Tests to check the connection.