on 2006 Jul 29 7:33 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.