Skip to Content
Author's profile photo Former Member

SAP HANA: Exploring data using SAP Visual Intelligence

Hello SCN,

SAP Visual Intelligence is SAP’s latest innovation in the SAP BusinessObjects Explorer solution family. It 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. — As mentioned by SAP 🙂

Let us see what SAP says that we can do with SAP HANA using SAP Visual Intelligence:

SAP Visual Intelligence 1.0 on SAP HANA provides the following capabilities:

• Direct connectivity to huge volumes of HANA data online

• Consume HANA analytic and calculated views

• Enrich HANA analytic view with geographical information (maps)

• Consume time hierarchies created in SAP HANA

Now, In this document let me walk-through some of the experiences I had while using this tool for first time to consume an Analytic View created in SAP HANA


Step 1: logging into Visual Intelligence


Step 2: Now we need to create a “New Document” as shown below:


Step 3: Now let us connect to our HANA System as shown below:


Once we connect to HANA System, we will be able to see all the Analytic Views and Calculation Views as shown below:

I guess you can see all the views which are created on this server by many “HANA” Enthusiasts, our peers, let us choose one.

Now we have a option to “Preview and Select Data” means what data we want to show or hide which is available in the view, Once you press “select” it will take you to the below screen.

Now we can “uncheck” if we want to hide the “attribute” and we can also preview the data as shown below:


With this we are able to Connect to the required Analytic View in our hana system.

Step 4:  Now let us feel the magic of “Visualization” options available in SAP HANA as shown below:

Choose the required attribute with which you want to make a new chart as shown below:


Now it displays a Bar graph as shown below :


Well let us add one more attribute “Name” and see what happens, it automatically changes the chart as and when required. If you don’t like this chart you can always “Reset” it.


Now let us try some other charts, like “Pie Chart with Variable Slice Depth”. Immediately it will display the chart as shown below:



Now let us see the filter options, If you want to see the “Data” before you filter, you can select “Data” and filter as shown in the below screens, here am trying to keep a filter on “Country”



Now if you see the title is something weird in the above visualization, so if you want to change to something meaningful like “Revenue By Country” you can just click on it and change as shown below:


Now let us add a calculation like “Running_Max”. you can do as shown in the below:


Now we can see how our chart is now filled with “Running_Max” as shown below:


Step 5: Geographic display of the data:

Let us see how we can enable this, first you need to enable the “Geo” by creating a “Geographic hierarchy” as shown below:



If everything is matched, you will see as shown below:


And thus we created a “Geographic Hierarchy”

Now let us create one more for “CITY” , now you can see there are some missing values we have to manually solve these ambiguities.

Now with it we can see our “Geo Chart enabled” as shown below:


Step 6: “SAVE” and “SHARE”.


Step 7: Save the “Document”.

Hope you all felt the “Visual “treat using this SAP VISUAL INTELLIGENCE tool. Please do comment your views 🙂

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Syambabu Allu
      Syambabu Allu

      Dear Krishna,

      Nice document's very helpful................



      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Syam

      Author's profile photo Rama Shankar
      Rama Shankar

      Good job on the step-by-step. This tool looks like an enhanced version of SAP BO Explorer with direct access to SAP HANA analytical and calc views -  Thanks - Rama

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Exactly Shankar.. i feel the same.


      Krishna Tangudu

      Author's profile photo Former Member
      Former Member

      Hi Krishna

      Great job .

      Can you also mention technology behind this tool.Can we use this tool in place of dashboards?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Santhosh,

      As stated by Shankar, we can use this as an enhanced version of SAP BO Explorer , we cannot use this in place of dashboard designer which does more functionality than this.


      Krishna Tangudu

      Author's profile photo Former Member
      Former Member

      Good step by step explanation... Highly appreciated.


      Author's profile photo Former Member
      Former Member

      Thanks for the blog, it is very useful.


      Krishna Bodapati

      Author's profile photo Former Member
      Former Member

      Hi Krishna,

      I didn't have much hands on exp on this topic .. if i am asking wrong please correct me Krishna.

      First of all you done great job.

      I think it is very similar to  "SAP Xcelsius ".. Here we can use SAP HANA DB or not i am not sure ..

      please let me know both are same or its entirely different ?

      if both are same then can we use views[attribute and calculation view] and play.

      Thanks in advance