Skip to Content

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.


/wp-content/uploads/2014/03/1_415603.jpg

Activate the RIVER file. Now there will be three to ‘Generate Test Data’, ‘Data Preview’, ‘Odata Calls’

/wp-content/uploads/2014/03/2_415607.jpg

Click on Generate test data.

3A.jpg

Specify Sample Data

3B.jpg

I have selected ‘values from file’. To look a reasonable data, I have prepared a TEXT file with comma separated.

3C.jpg


Values for YEAR


3D.jpg

Data Preview

3E.jpg

Check the oData by clicking on ‘oData Calls’

oData.jpg

Go to SAP Lumira to create a DATASET

/wp-content/uploads/2014/03/5_415614.jpg

Choose SAP HANA database and click on NEXT for establishing a connection

/wp-content/uploads/2014/03/6_415615.jpg

Give the credentials to connect to HANA System and click on ‘Connect’/wp-content/uploads/2014/03/7_415616.jpg

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.

/wp-content/uploads/2014/03/8_415617.jpg

Click on ‘Prepare’

/wp-content/uploads/2014/03/9_415618.jpg

Prepare the data, Define Measures, Time and Geographic Hierarchy

10C.jpg

Create ‘Geographic Hierarchy’ for CITY


10A.jpg


Create ‘Time Hierarchy’ for YEAR

10B.jpg

10D.jpg

Hide the duplicate fields(CITY and other fields) from the dataset panel

/wp-content/uploads/2014/03/11_415619.jpg

Hide the fields which are not required and save the file. You can save it in ‘Local’ or “Cloud’.

/wp-content/uploads/2014/03/12_415627.jpg

Now Click on “Visualize”. Select DONUT CHART for Visualization

/wp-content/uploads/2014/03/13_415631.jpg


Donut Chart – Sales Revenue by City

/wp-content/uploads/2014/03/14_415632.jpg

Donut Chart – Sales Revenue by City – Year on Year by using TRELLIS option

/wp-content/uploads/2014/03/15_415633.jpg



Sources:

SAP HANA Academy | SAP HANA

http://www.saphana.com/community/hana-academy#lumira

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. Rafi Bryl

      Yes Benedict, the Odata documentation is generated automatically on activation. You can think of it as a human-readable version of $metadata (which is the XML representation).

      (0) 
    2. Shahid Mohammed Syed Post author

      SAP River is naturally exposed via OData. Any OData services that are specified in the SAP River code are also generated. In the Code i have defined it as @ oData

      At runtime, a client makes OData calls to retrieve and update data.

      (0) 

Leave a Reply