Weekly/Monthly Snapshot Report

[Former Member]

Hi,

I have now three cubes Daily,Weekly and Monthly cubes...

I had made copy of the daily cubes as weekly and monthly.. There is no difference as such structure wise...

But what extra i need to do to make these weekly snapshot report and monthly snapshot report..

Now all three cubes are added in multiprovider and multiprovider was used in the definition of the query..

For daily cube report though, i had simply restricted infoprovider as daily cube and designed the query..

But what about weekly and monthly snapshot reports?

as snapshot reports are basically meant for comparing time periods how i could achive the same in reporting?

What i am contemplating as follows:

1) Since these are comparing different times ( for weekly snapshot, you must have at least two different weeks of data to compare ) i guess we need to include a time chararistic 0CALWEEK for Weekly snapshot, 0CALMONTH for Monthly snapshot..

But even after including this time charactristic, how i would be comparing?

i am not clear on how to creata a snapshot report

What one has to do in the weekly and monthly cube to be able to compare the data on weekly/monthly basis?

[Former Member]

Hello Simran,I am asked to do a weekly snapshot scenario for our existing Cube.Can please Give me a step by step how how to implemented yours.

Thank you in advance!

[Former Member]

Simran,

Weekly Snapshot means entire data has to restated against each week.

For example to check open orders status week wise, entire open orders(till end of current week) has to restate against current week. at end of the week, need to pass remaining open orders as next weeks snap shot.

In this way we will get snapshoting of open orders week wise. We can use these weeks to compare.

For weekly snapshot add week to cube, and at end of each week pass current week closing balances as next week opening balances + transactions in that Week gives snap shot of that week.

For example Check: [HOW TO HANDLE INVENTORY MANAGEMENT SCENARIOS IN BW (NW2004)|http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e328]

Snapshot scenario.

Hope it Helps

Srini