Skip to Content
0
Former Member
Dec 08, 2006 at 06:20 AM

Inventory SnapShot Cube and Daily Load Cube

51 Views

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