Hi,
If you have a monthly fact table that gives you the end of the month balances, and a change table that for each month gives you changes since the beginning of the month, how do you implement this in MSAS so that users can pick any day in the calendar and see the inventory levels for that day?
The change table gets records only when a balance changes. It has both the new balance for that day and the change amount since the last change.
Thanks,
Shab
If you have a monthly fact table that gives you the end of the month balances, and a change table that for each month gives you changes since the beginning of the month, how do you implement this in MSAS so that users can pick any day in the calendar and see the inventory levels for that day?
The change table gets records only when a balance changes. It has both the new balance for that day and the change amount since the last change.
Thanks,
Shab