Inventory Management Snap Shot Scenario Please Help!

Hello BW Gurus. My current client needs to report on average inventory for the last 12 months, but the material movements cube will only allow me to report on the average inventory for the last day of the current month. I was advised to use the snap shot scenario and Take a 12 times Valuated Stock into the query ,but restrict with 12 different date variables ( Customer exit variables) and then use formula to find the Average.

Is this the right solution?

If not how should provide a solution?

Thanks