Git is used in calculation view modeling to:

C. Manage versions of source files: It provides version control, enabling tracking and rollback of changes in calculation views and other project artifacts.

While collaboration (D) and build automation (B) are benefits of Git in general, the primary purpose in this context is version management. Displaying dependencies (A) is unrelated to Git.

When creating a calculation view that accesses a table in an external schema:

A. Synonym: Synonyms act as aliases to access external schema objects. They are required to integrate external tables into the calculation view.

D. Authorization: You need appropriate schema authorizations to access the external table through the synonym.

A remote source (B) is used for accessing remote systems, and an SQL view (C) is not necessary for this scenario.

Apruning configuration tableis used to define conditions for pruningdata sources in unionswithin a calculation view. Pruning removes unnecessary sources from the query execution, optimizing performance by reducing data processed.

The block must start with a node that defines a table as a data source (C):Parallelization blocks are designed to work with table-based nodes as starting points for splitting workloads.

Only one block can be defined across a stack of calculation views (D):This restriction ensures consistency and avoids conflicts during parallel execution.

The.hdiconfigfile in an XS Advanced project is used to specify whichHDI plug-insare available for use in the project. These plug-ins define how different file types are processed and deployed within the HDI container. For example, plug-ins might be defined for handling calculation views, tables, or sequences.

f you rename the design-time file of the dimension calculation view without renaming the runtime view and adjusting the reference:

Building the dimension view as a single object (A) is successful:This operation affects only the renamed file and does not impact other dependent objects.

Building the entire SAP HANA database module (B) is also successful:The module rebuild adjusts references at the runtime level for all objects, ensuring consistency.

For a calculation view of typeCUBE, the default top view node is theAggregationnode. This node summarizes data based on specified grouping and performs aggregations, making it suitable for analytical purposes and star schemas.