Inventory snapshot

[#1]

Hi,

I have to store inventory snapshot for total stock quantity in a new cube. Daily movements are captured through delta everyday in a different cube.

Now i am planning to create a query on regular cube and through APD fetch snapshot to the new cube. I only need total stock.

I am unclear about below points

1. I need snapshot at Material,plant,batch,sloc and stock type and there are no time characteristics too be used, i mean full snapshot.Will it work with aforementioned approach?

2.The new cube ha no BWA indexes on it since its not available in system. If i fetch full snapshot from query built on this cube using APD will it be performance efficient , i mean APD run time.

Regards

[Former Member]

Hi Nayab,

To your two questions:

I need snapshot at Material,plant,batch,sloc and stock type and there are no time characteristics too be used, i mean full snapshot.Will it work with aforementioned approach?

Yes. Considering that you don't use time characteristics, the load will always give you the stock qty as on the date of the load.

 If i fetch full snapshot from query built on this cube using APD will it be performance efficient

As long as you regularly compress the cube with marker update, the performance should be fine w.r.t. the cube. However, APDs in general have poorer performance than the queries they are built on. It might be good to keep that in mind.

[Former Member]

Thanks Suhas...

Keeping in mind APD performance i was thinking of below design. I need only Total stock qty in snapshot

1.Create a snapshot DSO (overwrite mode) and load it with 2lis_03_BX. In the field routine use Credit/debit indicator or processing keys whichever is suitable to fill a custom Key figure ZTOTALSTOCK (multiply with -1 for debit and vice versa).

2. Load all the movements in snapshot DSO from begining of time by filling set-up for 2lis_03_bf.

3. Create new DSO in summation mode and feed it from Overwrite DSO.(To enable delta loads within BW later on)

4. Init 2lis_03_bf

5.Do regular delta later on

Will it work?

Regards

[Former Member]

It could work but inventory is a tricky area. I would not recommend a roll-your-own-inventory approach unless you understand it really well from a functional and technical point of view.

The concept of snapshotting has been explored before on SCN. See below the doc that explains it:  http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e...

It is a little complicated and could be overengineering as well depending on how serious the performance problems are. It would be better to check out the simple APD-based approach first and see whether there is really a major performance issue. If not then you can move on to the approach described in the doc.Whichever approach you take, try to also incorporate other stock KFs (such as valuated stock etc) in addition to total stock. It doesn't take any significant additional effort and users could very well ask for it in future anyway.

[Former Member]

Dear,

If you run query from Bex, does it take long enough to execute if this is so then you might try to tweak and add filters in your query. The time that it takes to execute will be same as when it loads new cube via APD. There might be little bit of difference but will be same.

You can schedule run for APD in background so even if it takes long, you don't have to wait.

Thanks & Regards,

M