Explore Data in SAP Visual Intelligence from SAP HANA source

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 Online/Offline Cube.

SAP Visual Intelligence is a desktop-based visualization and data manipulation solution that allows business users to acquire data from a variety of corporate and personal data sources and manipulate without any scripting. They can then analyze this data, with beautiful visualizations, quickly discovering unique insight that can be easily shared, shaping the business faster than ever before.

SAP Visual Intelligence is quick to download (approximately 150 MB) and install. There is no configuration required or Information Spaces to create

Procedure to connect HANA with SAP visual intelligence and visualize the data:

1. Choose Start all programs and select SAP Business Intelligence -> SAP Visual  Intelligence

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

3. In the next screen, you will get source CSV, Free Hand SQL, HANA Offline, HANA Online, MS Excel, Universe 3.X and Universe 4.X.
Select and double click on ‘HANA Online’.

4. Enter SAP HANA Server credientials.

HANA Server: xxxxxxxx
HANA Server Instance: 01
User Name: SULABH_USER
Password: xxxxxxx

Then click on “Connect HANA Instance”

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

 6. Select the required view (AN_SFLGHT) and click (preview and select data option). In the next screen you will have 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.

Press Ok to continue.

7. Go to Visualize -> select Attribute and Measures (In this scenario I want to analysis CARRID, Price and CUSTTYPE). So I added measures to Y-Axis and attributes to X-axis. Now the report looks like below:

Added CUSTTYPE on thrillers

 8. We have save the chart by click on “Save” option in Report pane. We can share the same analysis to others using “Publish dataset to HANA, Publish to StreamWork, Publish dataset to explorer, send visualization to mail” option in “share” screen.

Sulabh Bartaula 
SAP HANA certified consultant 
+358 40 4163 717 
sulabh.bartaula@sapfox.com