HANA Demo DB Setup
Before we start generating insights from SAP HANA, we need to import a demo content provided by SAP called SHINE. In this step we will import the package, run the demo app and populate the database with demo data. We will also install Power BI Desktop app so we can start working with the SAP data in the next sections.
Loading Sample data model (SHINE)
The steps required are:
-
Go to the Bastion host.
-
Download the HCO_DEMOCONTENT from SAP SHINE GitHub Release page
-
On the Bastion Host, open Hana Studio.
-
Click File -> Import
-
Select the package type. Under SAP HANA CONTENT select Delivery Unit and click Next
-
Select the HDB Database and click Next
-
Click on Client, Browse, select the downlaoded file and click Finish
-
Wait until the import job completes successfully.
-
Now, let’s add permissions to the user SAPHANADB. On Hana Studio, open HDB, open Security, open Users and select SAPHANADB. Click on the Plus sign and search for the role sap.hana.demo. Select sap.hana.democontent.epm.roles::Admin and click OK.
-
Make sure the role has been selected and click the Execute green button on the top right.
-
Let’s test the XS app and populate the database. On the bastion host, go to https://vhcals4hcs.dummy.nodomain:44301/sap/hana/democontent/epm and click Check Prerequiisites
-
Click on the Generate Time data and Create Synonyms and wait for the green checkmark.
Power BI desktop setup
Now the HANA database has the data model and the mock data, we need to install Power BI desktop so we can start building !
- Go to the Bastion Host and Download Power BI Desktop
- Proceed with the default installation process of the app.
- Make sure you have followed the steps described on the Environment Setup section on the MICROSOFT ON-PREMISES DATA GATEWAY INSTALLATION section so we can communicate via the gateway.
- Open the Power BI Desktop app and clear the initial splash screens. Click on File
- Go to Options and Settings and click on Options
- Select Direct Query and check the Treat SAP HANA as a relational database
Alright we are ready to start working with Power BI and data.
On the next two sections we will use two scenarios with PowerBI and Native HANA integrations:
- Analyzing data directly from SAP HANA published objects (#2)
- Analyzing data from custom queries with mutiple datasources including SAP HANA (#3)
Choose your desired path (or both) and let’s go !