Multiple choice technology architecture

You are in the process of designing a cube named InvStock. The measure group in the cube will have a measure named TotInventory that will be used to determine the total inventory stock for the manufacturing department at the end of quarter. What should you do to determine the inventory stock at the end of quarter?

  1. Define the TotInventory measure as a semi-additive measure

  2. Define the TotInventory measure as an additive measure

  3. Define the measure group as a semi-additive measure group

  4. Define the measure group as an additive measure group
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

End-of-quarter inventory is a snapshot measure, not additive across time. You don't sum daily inventory across the quarter. Semi-additive measures can be summed across some dimensions (like products) but not across time. TotInventory should be defined as semi-additive with LastChild or LastNonEmpty aggregation over time.

Keep practicing — related questions