HANA Modeling Flashcards
When you activate design-time artefacts in the SAP HANA Repository it becomes a runtime objectin
SAP HANA Catalog
The database persitence model defines which artefacts
Schema,
Views,
Tables
When implementing the data persitence model in XS classic you can use
Core Data Services (CDS) syntax
HDBtable syntax
True or False: A CDS document resides in the Repository and can be transported to other systems in a Delivery Unit
True
As of SP11 Attribute views have been deprecated and replaced with
Graphical Calculation Views of type DIMENSION
True or False, SAP HANA reports directly on physical tables and persists the results also known as materilization
False
In Data Modeling terms, Facts are also known as
Metrics, Measures, Key figures
The business reuirements is to model a long complex join path with only Attributes/Master Data. Choose the type of Calculation View to use
Calculation View with type DIMENSION
A Union node allows the data modeller to
Combine data from two or more data sources
Input parameters can be used
To filter data
Within expressions of calculated columns
Input and output parameters are not optional with procedures
True
Analytical Privileges are designed to
Restrict users access to different portions of the data from the same Information View