Skip to Content

Hi

I have loaded some sales data into SAP Hana and with the help of SAP Visual Intelligence i have created some dashboard View.

Retrieving data from Hana can be either Online Mode or Offline mode. Only Analytic View and calculation View can be retrieved.

Hana Online :

When we retrieve data from SAP Hana Online mode you will find the below changes:

1. Prompts for authenticated user entry to access Hana DB.

2. Data manipulation cant be done as the data is just reported directly from Hana.

3. Hierarchy enrichment and enhancement are based entirely on the Data modelling.

4. Update in the data will be reflected when refreshed.

Hana Offline :

When retrieval done in offline mode the entire data set available in the view will be fetched and we can perform manipulation, Hierarchy enrichment and even merging two data set with least case of one common field is mandatory.we can save the data set and the Dashboard view . There will not be prompt for any User name or password like online mode. But update of data in Hana DB will not be reflected as we have fetched the data already in offline mode.

But most of the case we use online mode of retrieval as the data update are reflected in our view.

Here i have retrieved sales data from Hana in Offline mode and created some views.

Geographical View

sapvi_geographic_multi_choropleth_HANA_Sales_Data_Demo_xlsx_Data3890351214342293439.png

Stack Chart

sapvi_businessgraphics_vertical_stacked_bar_HANA_Sales_Data_Demo_xlsx_Data4847802259095287012.png

Donut Chart


sapvi_businessgraphics_donut_HANA_Sales_Data_Demo_xlsx_Data5635251516707638880.png

3D Column chart

sapvi_businessgraphics_3dbar_HANA_Sales_Data_Demo_xlsx_Data3683321841959207493.png

Line Chart


sapvi_businessgraphics_line_HANA_Sales_Data_Demo_xlsx_Data4346546859270399192.png

Area Chart

sapvi_businessgraphics_surface_HANA_Sales_Data_Demo_xlsx_Data7384490759823971098.png

   Line chart – Treillis by Year


sapvi_businessgraphics_multi_line_HANA_Sales_Data_Demo_xlsx_Data8113175831052432391.png

Radar chart


sapvi_businessgraphics_radar_HANA_Sales_Data_Demo_xlsx_Data8462492783553606664.png

Tag Cloud chart


sapvi_businessgraphics_tagcloud_HANA_Sales_Data_Demo_xlsx_Data6527940773820546034.png

   Thanks & Regards,

     Karthik Kumar

Bi logo.png

   www.visualbis.com

   M: +91 7418855825
   W: (044) 4205 6027

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply