- Understanding Modeling Terminology:
**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:
Top comments (0)