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 HANA: Using Hierarchies

In SAP HANA, we have a choice of creating 2 types of hierarchies:

1. Level Hierarchy
2. Parent Child Hierarchy 

Level Hierarchy:
     Each level represents a position in the hierarchy. For example, a time dimension might have a hierarchy that represents data at the month, quarter, and year levels.Each level above the base (or most detailed) level contains aggregate values for the levels below it. The members at different levels have a one-to-many parent-child relation. For example, Q1-05 and Q2-05 are the children of 2005, thus 2005 is the parent of Q1-05 and Q2-05.
Hierarchies and levels have a many-to-many relationship. A hierarchy typically contains several levels, and a single level can be included in more than one hierarchy.

In our example, let us take “Level Hierarchy”.

Attribute View creation in SAP HANA(Using Single and Multiple Tables)

In this document, I am going to explain the steps involved in creating Attribute View in SAP HANA.
We can create Attributes Views....

1) Using single or Multiple Tables
2) Using existing attribute view to enhance your current one ( you want to show material description for each material number).

1) Using Single or Multiple Tables:
The below diagram shows the major steps involved in creating Attribute View.

The pre-requisites to create Attribute View are..

i) Tables should exist with data

ii) Package should exist.

In my earlier documents I have shown how to create tables and package.

• http://scn.sap.com/docs/DOC-25922
• http://scn.sap.com/docs/DOC-25996

Now we will discuss the steps involved in creating Attribute View.