Access HANA tables created by SAP RIVER Code in SAP Lumira
Correction: This blog as earlier stated not using OData, instead we are using to access the HANA catalog tables created by the SAP River program.
RIVER code when activated creates tables and oData for the entity. The table created by RIVER code will be used to get the data from SAP HANA into SAP Lumira for preparing dataset. This dataset will be used for Visualization.
Only SAP HANA Analytic Views can be used in SAP Lumira for preparing datasets.
In this blog we will use HANA tables created by SAP RIVER in SAP Lumira for preparing data sets.
Creating a file with extension .RDL in RIVER environment.
Activate the RIVER file. Now there will be three to ‘Generate Test Data’, ‘Data Preview’, ‘Odata Calls’
Click on Generate test data.
Specify Sample Data
I have selected ‘values from file’. To look a reasonable data, I have prepared a TEXT file with comma separated.
Values for YEAR
Check the oData by clicking on ‘oData Calls’
Go to SAP Lumira to create a DATASET
Choose SAP HANA database and click on NEXT for establishing a connection
Shortlist the table by using a keyword. Select the columns which are required by checking/unchecking the box. Click on create to create a DATASET.
Click on ‘Prepare’
Prepare the data, Define Measures, Time and Geographic Hierarchy
Create ‘Geographic Hierarchy’ for CITY
Create ‘Time Hierarchy’ for YEAR
Hide the duplicate fields(CITY and other fields) from the dataset panel
Hide the fields which are not required and save the file. You can save it in ‘Local’ or “Cloud’.
Now Click on “Visualize”. Select DONUT CHART for Visualization
Donut Chart – Sales Revenue by City
Donut Chart – Sales Revenue by City – Year on Year by using TRELLIS option