What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question.
Correct Answer: B,D
SAP HANA calculation views are flexible information views that you can use to define more advanced slices on the data available in the SAP HANA database. Calculation views can be created using graphical or script-based editors, and can include any combination of tables, column views, attribute views, analytic views, and other calculation views. Calculation views can also support complex expressions, multidimensional analysis, currency conversion, hierarchies, and other analytic capabilities. Some general characteristics of calculation views are:
* Need database tables to execute. Calculation views are based on the data stored in the SAP HANA database tables, either in column or row format. Calculation views can access data from local or remote tables, as well as virtual tables that are mapped to external data sources. Calculation views can also use data from other information views, such as attribute views or analytic views, which are also based on database tables. Calculation views do not store any data themselves, but rather perform calculations on the fly when queried.
* Do NOT need an application server to execute. Calculation views are executed by the SAP HANA Calculation Engine, which is a component of the SAP HANA database that handles the processing of complex calculations and transformations on the data. Calculation views do not require any application server or middleware layer to run, as they are directly exposed to the reporting tools and applications via SQL or MDX interfaces. Calculation views can also be accessed by SAP HANA extended application services, advanced model (XS advanced), which is a framework for developing and running applications on the SAP HANA platform.
The other options are incorrect because calculation views do not need an application server to execute, nor do they not need database tables to execute. These are the opposite of the correct characteristics of calculation views. References:
* Using Calculation Views - SAP Help Portal
* Calculation View Instantiation Process - SAP Help Portal
* SAP HANA Calculation Engine - SAP Help Portal
* SAP HANA Extended Application Services, Advanced Model - SAP Help Portal
* [HA300 - SAP HANA 2.0 SPS06 Modeling] - SAP Training