Currently Being Moderated

How to explore data in SAP Visual Intelligence with SAP HANA as source

Hi Everyone,

 

In this article I would like to provide you the information about how to use new SAP BO Reporting tool SAP Visual Intelligence with SAP HANA in Cloud share HANA Sand Box.

 

You will have Visual Intelligence icon on desktop, just double click on it.

 

1.png

Now you will get below screen, when you select ‘New Document’.

 

2.png

In the next screen, you will get ‘HANA Online Cube’ under New Data Source screen, select the same.

 

3.png

Now system gives you screen where you have enter HANA system

 

4.png

Provide the below details (You will get this from in-memory team)

 

HANA Server: hanasvr-10 (number varies from 01 to 10)


HANA Server Instance: 00 (Same for all)

 

User Name: p1024406 (Your registered SID/PID)

 

Password: *********


Then click on “Connect HANA Instance”.

 

Once the connection is successful, you will get all the available Analytic/Calculation views in right side as shown below

 

5.png

 

Select the required view and click (preview and select data option). Now click on ‘Connect’

 

6.png

 

In the next screen you will all the attributes and measures available in the selected view. By default all the objects will be selected, if you don’t want any objects for reporting then you can unselect here.

 

7.png

 

Note: We can search by giving name in sear bar also.

 

The below is the screen where we actually work on report format using the fields we have in source view (Analytic/Calculation view)

 

8.png

 

We have 4 main sections in the above figure.

 

Section1: In this pane we have all the attributes, measures and hierarchies which are available in the selected Analytic/Calculation View

 

Section2: From 1st pane we have to drag and drop the fields to this section to get the report in pane4.

 

Section4: Based on the fields we select from 1st pane we get the report here.

 

Section3: Using this option we can change the format of report (bar chart, pie chart, line chart, scattered chart, bubble chart). Bubble chart used in recent Olympic 2012 also.

 

Now I have taken EFASHION analytic view for this exercise.  In this scenario I want to analysis on Amount_sold, Quantity_Sold by Shop_ID.

 

So I added measures to Y-Axis and attributes to X-axis. Now the report looks like below

 

9.png

 

For measure you can also change the aggregations in measures section

 

10.png

 

The same report will look as below with bubble chart.

 

11.png

 

Note: If you are using bubble chart, then you should have min 3 measures, so i added ‘Margin’ also to the chart. We can add max of 4 measures in bubble chart.

 

Now we are doing this entire part in ‘Visualize’ screen. The other playing areas are ‘Data’ and ‘Split’.

 

You can see the images below.

 

“Data” Screen

 

12.png

 

“Split” Screen:

 

13.png

 

Once the preparation is done, we have save the chart by click on “Save” option in Report pane.

 

We can share the same analysis to others using “Email” option in “share” screen.

 

14.png

 

Hope this document helps to have quick start on SAP Visual Intelligence.

 

Happy Learning.

Comments

Delete Document

Are you sure you want to delete this document?

Actions