Our requirement from the snapshot cube is to provide queries which show end of month balances similar to as what is shown if I run queries from the Standard daily cube (0IC_C03).
The scenario is as follows:
Query requirements are to show ending balances for the period:
Details are as follows
1) I create a query based on the 0IC_C03 cube, the characteristics are say for example plant and fiscal period and the key figure is Quantity Stock
The results will display the balance at the end of each period so for example
The Key Figure in this cube is non cumulative and is 0TOTALSTCK
Period: 01 Quantity: 0
Period: 02 Quantity: 5
Period: 03 Quantity: 8
Period: 04 Quantity: 2
Period: 05 Quantity: 2
Period: 06 Quantity: 2
Period: 07 Quantity: 2
2) I create the same query off a version of the SnapShot cube as defined in the How to Inventory guide
The results displayed are the movements (changes)
Period 02 Quantity: 5
Period 03 Quantity: 3
Period 04 Quantity: -6
Has anyone got a solution so that I can have the same result set for example 2 than what I get in example 1?
At the moment the approach I plan to take is to datamart 0IC_C03 and work with the cumulative key figures which are used in 0TOTALSTCK. I would like thoughts on this approach and solutions otherwise. Thanks