cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Management Snap Shot Scenario Please Help!

Former Member
0 Kudos
311

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rajeev,

This is a correct solution if you have a cube where you can determine the historical stock (i.e. the stock value or quantity on the respective months).

You can then indeed create time variables (probably via userexit) and create 12 key figures where you restrict each one to a time variable corresponding to the respective months. The query can then calculate the average.

If your cube can calculate historical data, it is probably a very big cube so you might have to take performance considerations into account.

An alternative is to create a new cube to store the snapshot of the inventory at month end. You then do a full load into this cube ex. month end or month begin. You update a characteristic with the 'snapshot date', ex. the system date. A multiprovider over your snapshot cube and your normal cube will then provide the information you want. You will have to create a query with 12 key figures where each key figure is restricted to the different months and calculate the average accordingly.

Please assign points if this solved your problem.

Best Regards,

Filip