How to Establish OLAP Connection in SAP BO Analysis
Establishing an OLAP Connection
SAP BusinessObjects Analysis, edition for OLAP relies on the OLAP connections defined in your SAP BusinessObjects BI platform for the connection to SAP NetWeaver BW. So before we are going to learn more about SAP BusinessObjects Analysis, edition for OLAP and the product capabilities, we will have to configure a new OLAP connection towards our SAP NetWeaver BW system.
- Open the Central Management Console via Start > All Programs > SAP BusinessObjects Enterprise XI 4.0 > SAP BusinessObjects Enterprise > SAP BusinessObjects Enterprise Central Management Console
- Set the authentication method to SAP.
Central Management console Log on Diagram
- Logon with your SAP credentials towards you SAP NetWeaver BW System
The usage of Single Sign On for your OLAP Connection does require that your SAP BusinessObjects BI environment is configured with the SAP authentication. The setup and installation of SAP BusinessObjects BI 4 is not part of this book, as this is already covered in my book Integrating SAP BusinessObjects BI Platform 4.x with SAP NetWeaver available with SAP Press.
Central Management Console Home Diagram
- Select the entry OLAP connections in the category Organize.
- Select the button in the toolbar to create a new connection
OLAP Connection Diagram
- Enter your system details according to below OLAP Connection Details Table
|Name||Here you can enter a name for the OLAP connection. The name will then be shown to the user when creating a new workspace. Example: SAP BW|
|Description||Here you can enter a description for the OLAP Connection, which will be shown to the user when creating a new workspace. Example : SAP NetWeaver Demo InfoProvider|
|Provider||Here you need to select the type of data source that you will be using. In our example: SAP NetWeaver Business Warehouse.|
|Server Type||Here you can choose between an Application Server (Server) or a Message Server (Group) based connection, depending on your SAP landscape|
|System||Here you need to enter the three digits System ID of the SAP server. Example: IH1|
|Server||Here you need to enter the full qualified server name of the application server. The entry Server is only shown, when you select the Server Type Server.Example: ihilgefort.dyndns.org|
|System Number||Here you need to enter the two digit system number of your SAP server. The entry System Number is only shown, when you select the Server Type Server. Example: 01|
|Group Name||Here you need to enter the name of the Logon Group configured for your SAP system. The entry Group Name is only shown, when you select the Server Type Group. Example: PUBLIC|
|Message Server||Here you need to enter the full qualified server name of the Message Server. The entry Message Server is only shown, when you select the Server Type Group.
|Client||Here you enter the three digit client number of your SAP system. Example: 100|
|Language||Here you need to enter the language code that you would like to use to establish the connection to the SAP system. Example: EN|
|Save Language||The checkbox Save Language allows you to specify if the entered Language Code is being used always, or if the Preferred Viewing Local (configured in the user profile) is being used. When the option Save Language is activated, the entered Language Code is always used.|
|Authentication||Here you can configure which type of Authentication is used. You can choose between Pre-defined, Prompt, and SSO. Pre-defined will require you to enter a user and password, which then will always be used. Prompt will result in a logon dialog for all users when using this OLAP connection and the users will have to enter the credentials manually. SSO will leverage the entered SAP credentials and requires the users to be logged on with their SAP credentials.|
- Click Connect
- You will then be asked to enter your SAP credentials to logon towards the SAP NetWeaver BW system.
- Click OK.
- You are presented with the cube browser (see Figure 4.5) showing all InfoArea from the SAP NetWeaver BW system. As we are going to use BEx queries based on the SAP NetWeaver Demo model, we are selecting the SAP NetWeaver Demo model.
Cube Browser Diagram
You can configure OLAP Connections to be based on the SAP NetWeaver BW system, on an InfoArea, on an InfoProvider, or on a single BEx query. When creating a workspace the user will always use a BEx query and depending on which level the OLAP Connection has been defined, will see a list of queries, or InfoProvider and queries, or even InfoArea.
For example if the OLAP Connection has been defined on the InfoProvider level, like in our previous steps, the user will see all BEx queries available for this InfoProvider.
OLAP Connections & Authorizations:
Often people ask on which level they should define the OLAP Connections, and the answer depends to some degree also what has been defined in SAP NetWeaver BW already.
In case you are using naming conventions to limit access to InfoProvider and BEx queries already in SAP NetWeaver BW, a single OLAP Connection configured with Single Sign On (SSO) might be all that is needed. In case you are not using such naming conventions in SAP NetWeaver BW, you might have to create multiple OLAP Connections and use security settings in your SAP BusinessObjects BI platform to grant or deny access to certain OLAP Connections to your users.
- Set the Authentication to the option SSO.
- Click Save.
- Close the Central Management Console.
We know created an OLAP Connection in the Central Management Console (CMC) and can use this connection in combination with SAP Business Objects Analysis, edition for OLAP. In the next section we will use this newely created OLAP connection and create our very first workspace.
Enroll for Instructor Led Live SAP BO Training