HANA data models with Calculation Views enable fast analysis of your data. With Composite Providers, they can be seamlessly integrated into BW/4HANA.
Description
Data modeling with Calculation Views in the SAP HANA database offers extensive possibilities for virtualizing reporting. In contrast to the classic data warehouse approach, data processing takes place at reporting time. The virtual data models enable much more flexible reporting, in which requirements can be implemented in an agile manner.
Agenda
-
Categories of Calculation Views
- Cube
- Dimension
-
Node types
- Projection
- Aggregation
- Union
- Join
- Star Join
-
Calculated and restricted columns
-
Time dimensions
-
Parameters and variables
-
Currency and unit conversion
-
Analytic privileges
-
Programmatic modeling with table functions
-
Integration into SAP BW: generating and using the external views of BW objects
-
Outlook: Business Application Studio and HANA Cloud
About open training
Offene Schulung im Mafinex Technologiezentrum in Mannheim.
Prerequisites
Understanding of reporting requirements
- Basic knowledge of database modeling and querying
Target group
HANA developers and BW consultants