1) HANA Studio
2) Schemas
3) Attribute Views
4) Analytic Views
5) Calculation Views
Schemas: are used to store row and columnar tables. Tables are used to store data.Tables are of type row or columnar. Schema owners have to grant permission to other schema owners, before the tables can be accessed.
Attribute Views: Similar concept as “Dimensions” in SAP BI-BEX or SAP BO or SAP BPC. Some can be mapped, some can be derived, some can be looked up and some can be calculated, using tables defined in Schemas. Format wise; they can be either date, time, currency, unit, text, hierarchy or a numeric key. Once created, these can be used as “Dimensions” in the Hana analytics.
Analytic Views: It is the combination of numbers (Keys) and characteristics (attribute views) to produce required multidimensional analytics. This combination is generally configured in the “LogicView” tab. Keys are called Privated Attributes, when are summerized/aggregated, called “Measures”. Calculated Measures can be created using one or more measures. Similar concept in SAP BI-BEX: “Structures”.
Calculation Views: Calculation Views are combined with Analytic Views to provide complex calculations and other “Calculated” Views for Analytical purposes. Multiple Analytic Views can be combined and aggregated in a Calculation view. GUI can be used to build these or a script. Functions are allowed (within the scripts) to optimize parallel and multi CPU core processing. milar concept in SAP BI-BEX: “Calculated Key Figures”.