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]

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