Measures are simple measurable analytical elements. Data that can be
quantified and calculated are called measures. They are similar to
Key Figures
in SAP BW. Measures are defined in Analytic and Calculation Views.
Three types of measures can be defined in Information Modeling:
- Simple Measure is a measurable analytical element that is
derived from the data foundation i.e. defined in the fact table. For
example, SALES_AMOUNT.
- Calculated Measures are defined based on a combination
of data from OLAP cubes, arithmetic operators, constants, and functions.
For example, Net Revenue equals Gross Revenue - Sales Deduction,
assigning a constant value to a measure for some calculation.
- Restricted Measures are used to filter the value based
on the user-defined rules for the attribute values. For example, Gross
Revenue of a material for country = US.
No comments:
Post a Comment