What are the various types of measures?

1.	What are the various types of measures?
Answer» There are three types of measures; they are: 1. Non- additive measures: These are the ones on which no AGGREGATION function can be applied. EXAMPLE: Ratio or PERCENTAGE Column. 2. SEMI- additive measures: These are the ones on which some of the aggregation functions can be applied. Example: Account Balance or FEE Rate. 3. Additive measures: These are the ones on which all the aggregation functions can be applied. Example: Number of Units Purchased.

Answer»

There are three types of measures; they are:

1. Non- additive measures: These are the ones on which no AGGREGATION function can be applied. EXAMPLE: Ratio or PERCENTAGE Column.

2. SEMI- additive measures: These are the ones on which some of the aggregation functions can be applied. Example: Account Balance or FEE Rate.

3. Additive measures: These are the ones on which all the aggregation functions can be applied. Example: Number of Units Purchased.

Discussion