How to Connect SAP Lumira with SAP HANA – An Easy to Learn Process
In our series to learn how different reporting tools connect to SAP HANA, the next tool is SAP Lumira. SAP Lumira is an efficient data analysis and visualization tool. We will learn, how to connect SAP Lumira with SAP HANA database in this tutorial.
But, let’s first learn the working of SAP Lumira with SAP HANA.
SAP Lumira and SAP HANA – Working
SAP Lumira is a self-service business intelligence software which is used solely for data designing, data visualization, and analysis. It provides rich and interactive visualizations such as charts, maps, infographics, etc.
Lumira connects directly to SAP HANA (OLAP connection) using a JDBC connection and SQL as the communication language. It can access data from Excel, SAP HANA and many more data sources. Users can acquire data from SAP HANA information views, prepare the data for analysis and create visualizations using it. Also, Lumira can be deployed on-premise or is available as Software as a service as well.
Although SAP Lumira seems similar to SAP Business Explorer, they are not the same. The only difference is SAP Lumira provides advanced features, whereas Business Explorer is more basic to use.
Have you completed? – Web Intelligence Connection with SAP HANA
Connecting SAP Lumira with SAP HANA
In this section, we will step by step learn about how to connect to SAP HANA from SAP Lumira.
Step 1: Open SAP Lumira on your system. The main page of SAP Lumira will appear.
Step 2: Go to the File menu. Click on New.
Step 3: Add New Dataset
Now, you can either connect to SAP HANA directly and use data from the data models on an active connection or you can download the dataset from SAP HANA view into SAP Lumira to work with it. To do this, select the option Download from SAP HANA.
Click on Next to continue.
Step 4: SAP HANA Data Acquisition Connector
Enter connection parameters like Connect to, Server, Instance number, User name and Password. You can save the password as well. Click on Connect.
Step 5: Once you get connected to SAP HANA system, all the packages and information views present in those packages will appear.
You can select the view from which you want to use the data or search for the package or view of your choice in the search bar. Click on Next after selecting the view or package of your choice from the list.
Learn the types of Information Views in SAP HANA Information Modeler
Step 6: In the next dialog, you will get all the measures and dimensions available from the selected information view.
There are two separate columns for Measures and Dimensions. You can unselect or select a measure or dimension from the list from the checkboxes given beside them. Click on Create.
It may take a while to fetch and prepare the dataset.
Step 7: You can see the loaded data in the Prepare tab. One the left panel will be the list of Measures and Dimensions imported from SAP HANA. On the central pane, there will be a tabular representation of the selected fields.
You can also create visualizations from the Visualize tab. You can select from a bunch of options such as bar graph, line chart, pie chart, etc. Also, you will have all the necessary tools to prepare your visualizations using the imported data from SAP HANA.
From the Compose tab, you can create data stories.
Creating Visualizations in SAP Lumira
Step 8: You can create visualizations using data from SAP HANA.
Go to the Visualize tab after connecting SAP Lumira with SAP HANA.
On the left panel will be a list of dimensions and measures. You can select the visualization type from the box and select the dimensions and measures to be used in that visualization.
You can create different visualizations like a horizontal bar chart:
- Pie chart
- Donut chart
- Heat map
- Tree map
This concludes our tutorial on learning how to connect to the SAP HANA database from SAP Lumira. SAP Lumira is a reporting tool used to create informative tools.
We hope that you found our tutorial helpful. Please leave your valuable feedback in the comment section below.
Don’t miss to check the Scope and Future of SAP HANA