Creating an OLAP Connection


Advertisements

An OLAP connection is used to connect to HANA Information view or a data model and to directly import all the business objects defined in the Business Layer for reporting.

To create a new OLAP connection, right-click the Project name → New → OLAP Connection.

OLAP Connection

In the next window, enter the Connection name, Description (Optional) and click Next.

Note − You point an OLAP connection to a specific cube or to complete HANA repository. When this connection is used in any BO Reporting tool, you can directly import all objects in HANA Modeling view or can also view all published information views in the repository and select any of them for reporting.

Resource Name

Next, select an OLAP middleware driver. It shows a list of all available OLAP data sources. You can select any OLAP data source as per requirement.

Note − You don't need to create a Data Foundation, as an OLAP directly hits the Business Layer. You can define dimensions, measures, and other properties at the Business Layer.

Select the suitable middleware driver to connect to OLAP data source and click Next. To connect to HANA views, select SAP HANA → SAP HANA Client.

SAP HANA Client

To connect to HANA system, you need the following information −

  • Server Name
  • Instance Number
  • Authentication Details
HANA System

When you fill the above details and click the Next button, you have an option asking if you want this connection to point to a specific cube or to all cubes in HANA repository.

HANA Repository

Once this option is selected, click the Finish button at the bottom of the screen.

Now, you need to publish the connection to the Repository. Right-click Connection → Publish the Connection to the Repository.

Connection to Repository

When a new connection is created using Information Design tool, you have the following connection parameters that can be defined −

  • Connection Pool Mode − This is used to keep the connection active.

  • Pool Timeout − When you set the Connection Pool Mode to Keep the connection active for, it is the length of time in minutes to keep the connection open.

  • Array Fetch Size − This tells the maximum number of rows that can be fetched from the database.

Example

Let us consider an example. You enter a value of 25 and your query returns 150 rows. Hence, it will be fetched with 6 fetches of 25 rows each.

Array Bind Size − This field is not required for designing the Universe in IDT.

Login Timeout − It determines the minutes a connection attempts timeout and an error message is displayed.

There are various custom parameters that can also be defined such as ConnectInit, Hint.

Useful Video Courses


Video

SAPUI5 Online Training

25 Lectures 6 hours

Sanjo Thomas

Video

SAP Webi Online Training

Most Popular

26 Lectures 2 hours

Neha Gupta

Video

SAP Basis Online Training

30 Lectures 2.5 hours

Sumit Agarwal

Video

SAP C4C Online Training

30 Lectures 4 hours

Sumit Agarwal

Video

SAP MM Online Training

14 Lectures 1.5 hours

Neha Malik

Video

SAP WM Online Training

13 Lectures 1.5 hours

Neha Malik

Advertisements