SAP HANA: Information Models

SAP HANA's Information models are organized in packages

1. Attribute Views = Dimensions
2. Analytic Views = Cubes
3. Calculation Views = similar to virtual provider with services concept (BW)
1. Graphical
2. Script (SQL Script, CE Functions)
3. Calculation View enhanced with Analytical View
4. Analytic Privileges
5. Procedures
6. Decision Tables
7. Persistency Considerations

1. Scenarios  = different requirements and persistency models = checklist
1. Write or read intensive scenarios = Criteria for storage type
1. Write-intensive scenarios = smaller system tables = row storage
2. Read-intensive scenarios = column storage
2. Real-time Data access
1. Support of table type, and data type
2. Capability of data type transformation
3. Authorization
1. Authorization and privilege configuration applies to Attribute views, Analytic Views, and Calculation Views
4. Application/Client
1. SAP Business Objects Explorer è does not support filters in the queries on design time
2. Hierarchies è Supported by only SAP BusinessObjects Analysis and Excel
3. SAP BusinessObjects WebIntelligence è always retrieves and caches the max result set
4. Only Explorer, Excel & Analysis do currently consume additional meta data, e.g. multi language support
5. Functionality
1. Some complex algorithms can only be expressed in L language
2. Currency conversion is supported only in Analytic and Calculation views
3. A union can only be performed in a calculation view
6. Performance

1.