Recognises a measure without stated additivity
A semi-additive measure (a balance, an open count) or a non-additive one (a ratio) stored without saying how it may be aggregated. A BI tool sums it, and the result is wrong and looks right.
Can AI do this?
Not tested yet
No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.
What it looks like in practice
Expected result: The measure and how it may be aggregated
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: arrears_ratio summed across products; month-end account_ledger_balance_amount summed across months Acceptable: comment stating additive, semi-additive (not across time) or non-additive; numerator and denominator stored instead of the ratio (PHY-014)
Also known as: Measure without stated additivity (physical model)
Related knobits
Builds on
All 40 knobits of Design the physical data model.
Source: Review checklist 06-physical, row 27; C&B ("Data Warehousing Design": choosing the facts); S&W 16.6