An organization has actuals by day and budgets by month. Which semantic design supports comparison at month level?

Published
  1. Convert budget to a customer attribute
  2. Repeat each monthly budget on every daily transaction and sum it
  3. Remove the date dimension from both facts
  4. Model each fact at its real dimensional levels and aggregate compatibly

Comments — 0