DEV Community

Hiro
Hiro

Posted on

Learninig: Creating Calculation Views

  • Understanding Modeling Terminology:

Image description

**A fact table can be one table but it is often defined from a combination of tables to produce a view of a transaction, such as a sales order. Dimensions are then connected to the fact table to provide additional, descriptive information about the transaction, such as, the country of the customer.

**Semantics: used to describe the meaning of an attribute or a measure. (Example: currency of an amount).

**Calculation views: Perform a variety of data calculations to generate a meaningful result set.
-Are read-only and cannot change the data in database

  • The calculation views can bypass the application server and directly query the calculation views where data is calculated on-the-fly to Cloud in-memory database.
  • A dimension calculation view is used to expose master data from source tables.
  • Only build with attributes
  • Each calculation view can be used by another calculation views.
  • Adapt the behavior to the list of columns that are selected or projected on top of it.
  • All values in DCV (dimension calculation view) are listed individually. Any calculation demands a cube calculation view.

1) Design Time: Created or modified by a graphical or text-based editor.
2) Runtime: database catalog object (like, excel)

**Cube Calculation Views:
1)Private Columns: Defined inside the calculation view itself. The user has full control of these columns.
2) Shared columns: defined externally and used by more than one dimension.

** Time-Based Dimension Calculation Views:
1) Time-base DCV generates various date-related attributes from a base date.

** Sources supported in calculation views:

  • Row Table, column tables, virtual table, calculation views, SQL views and table functions
  • Virtual tables: reach external files from any location in your landscape, however affect data performance.

** Top View Node: generates the calculated data set before semantics are applied:

Image description

Top comments (0)