SAP HANA: Exploring data using SAP Visual Intelligence
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 🙂
Nice document ....it's very helpful................
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
Exactly Shankar.. i feel the same.
Great job .
Can you also mention technology behind this tool.Can we use this tool in place of dashboards?
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.
Good step by step explanation... Highly appreciated.
Thanks for the blog, it is very useful.
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