Connecting Lumira Designer to HANA

Pre-requisites to establish Lumira Designer Connection with HANA as source

When you own a HANA system and have many important prebuilt HANA Views, which incorporate important business logic, it makes sense to use this wealth of information as sources to design your dashboards rather than redesigning the same logic in the Universe layer and then using this as a source.

The ability to connect to HANA Views directly from the Designer will let the organization use these pre-built HANA views with business logic embedded in them as source and build informational and impressive dashboards that can be used for critical decision-making purposes.

Also, by connecting Live to HANA, we take the advantage of HANA’s in-memory processing. When HANA is used as a Data Source, the queries are delegated to HANA when any changes occur in the query’s initial view, meaning, when you use Drill Down functionality or use dimension swaps, Instead of loading data for ALL of the components in the View, HANA does Query Pruning, which will only fetch the data that is in use. Thus, improving the performance of Lumira Designer Dashboard by avoiding the storage of large data sets in its memory.

In this blog, we will walk through the necessary steps needed to establish a connection to the HANA system in SAP’s BI Platform, and then use this connection in the Lumira Designer to connect to HANA. Once the connection is made, it is pretty straightforward to use this data source and create a dashboard on data from HANA.

Pre-requisites – Create HANA Connection in BI Platform (CMC)

The first step to connect to HANA from Lumira Designer is to Create an OLAP Connection in the BI Platform. By doing this, you will establish a connection detail to connect to HANA, which can be used later in the Lumira Designer. Launch Central Management Console and open the OLAP Connections as shown below:

Create a new connection by clicking on the Connection button as shown below:

Now provide a name and description for this connection and from the Provider Dropdown, choose SAP HANA http as shown below:

In the Server Section, provide the server and port number. In this case, select the port at which the XS engine is running. For authentication purposes, you can set it to predefined, so the end users do not have to provide any credentials when using this connection (optional).

Once all this information is provided, click Save.

Connecting to HANA from Lumira Designer

Launch Lumira Designer and create a new document as shown below:

We will now provide a document name and click the Create button as shown:

Go to the Outline section and choose Data Sources and Right click and select Add Data Source as shown below:

Select the Browse button in the Add Data Source window and choose Browse Connections:

Now from the list of Connections, choose the connection we just created, which will be KFHANA_Connection, and click OK:

For a data source, browse and choose the data source you would like to build a dashboard on. In this case, we will choose Sales_by_Geography from AdventureWorks DW Folder.

Once you have finished choosing the needed data source, click OK and you will see the new data source available for your further use.

You will notice that the additional step of Editing the query in the query panel is not needed when using HANA Views.

You can now edit the initial view, like you would with any other data sources, and add the data elements that are needed for your dashboard.

Drag and drop the Country_Customer object to the Rows section and click “OK + Create Crosstab”

You will notice that the cross tab is now added to the dashboard.

Conclusion

In order for us to connect to a HANA system from Lumira designer, we first need to create an “SAP HANA http” connection in BI Platform and then use this connection in Lumira Designer to be able to connect to the HANA Views and use them as sources for the dashboard.

See more Business Intelligence insights or get future articles sent right to your inbox

increase your knowledge
increase your knowledge

Read More Lumira articles in these recent Blogs

Read More HANA articles in these recent Blogs

By |2018-09-02T17:39:35+00:00May 14th, 2018|Kingfisher, Tips & Tricks, Web Intelligence|0 Comments

About the Author:

Shaheen has more than 13 years of experience with a strong background in BI Analytics, Data Warehousing, and ETL Architecture. She enjoys working with clients finding solutions to their BI reporting problems. She has helped many healthcare clients with data cleansing projects, along with designing data marts and establishing BI reporting infrastructure. When she’s not cooking delicious food or enjoying hikes in the mountains, you can reach her at Shaheen.Makandar@kingfisherinc.com.