How to Establish OLAP Connection in SAP BO Analysis
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.
1. Open the Central Management Console via Start > All Programs > SAP BusinessObjects Enterprise XI 4.0 > SAP BusinessObjects Enterprise > SAP BusinessObjects Enterprise Central Management Console
2. Set the authentication method to SAP.
Establishing an OLAP Connection
Central Management console Log on Diagram
[ Related Article: Analysis Edition for OLAP ]
.png&w=16&q=75)
3. Logon with your SAP credentials towards your SAP NetWeaver BW System
SAP Authentication
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.
[ Related Article: SAP BO Interview Questions for Experienced ]
Central Management Console Home Diagram
4. Select the entry OLAP connections in the category Organize.
5. Select the button in the toolbar to create a new connection
OLAP Connection Diagram
6. Enter your system details according to below OLAP Connection Details Table
| Element Name | Description |
| 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 fully 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 fully qualified server name of the Message Server. The entry Message Server is only shown when you select the Server Type Group. Example: ihilgefort.dyndns.org |
| 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 login 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. |
7. Click Connect
8. You will then be asked to enter your SAP credentials to login into the SAP NetWeaver BW system.
9. Click OK.
10. 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.
[ Related Article: SAP NetWeaver Business Warehouse ]
Cube Browser Diagram
OLAP Connections
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 creating 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 newly created OLAP connection and create our very first workspace.
Explore SAP BO Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!
As a content writer and storyteller, Raunaak Mitra regards himself to be a prodigy in writing. He firmly believes that language is borderless, and anyone can write as long as they have a strong narrative capability and the ability to emote feelings into words. Authors like F. Scott Fitzgerald and R. K. Narayan have influenced him to keep the writing as simple as possible for anyone to understand. Other than being well-versed about technological trends like AI, Machine Learning, AR, VR, Gaming, Microprocessors, Cloud Computing, Industry 4.0, literally any technological advancement (old or new), he also shares a knack to curate fiction on sci-fi, satire, and thriller genres.
- SAP BO: Adding and Customizing Charts
- Adding or removing characteristics and key figures - SAP BO
- Charting in SAP BO
- Conditional Formatting – SAP BO
- Creating Totals and Subtotals - SAP BO
- Creating your own calculations In SAP BO
- Filtering Data in SAP BO
- Filtering Data with Focused Navigation – SAP BO
- Formatting options - SAP BO
- SAP BO Analysis Edition for OLAP
- SAP BO Product Roadmap
- SAP BO Analysis, Edition for OLAP and SAP NetWeaver BW
- Saving and Exporting - SAP BO
- Sharing information using Analysis Views In SAP Business Objects - SAP BO
- Sorting Data - SAP BO
- Suppressing Zero Values – SAP BO
- Using BEx Variables in your Workspace in SAP Business Objects
- Using Hierarchies In SAP BO
- Using “Pivot with” – SAP Business Objects
- Working with multiple connections - SAP BO
- SAP BusinessObjects Cloud Interview Questions
- Business Objects Interview Questions
- Business Objects Tutorial - SAP BO
- SAP BO Interview Questions And Answers