Answers

Question and Answer:

  Home  Data Architect

⟩ Tell us what are the different types of measures?

We have three types of measures

☛ Non- additive measures

☛ Semi-additive measures

☛ Additive measures

Non-additive measures are the ones on top of which no aggregation function can be applied. For example, a ratio or a percentage column; a flag or an indicator column present in fact table holding values like Y/N, etc. is a non-additive measure.

 155 views

More Questions for you: