Inventory Management SnapShot model

[Former Member]

In the How to guide it discusses on how to create a SNAPSHOT model for monthly loads.

Can I create a SNAPSHOT ODS and eliminate the Cube as part of my Data Flow and if so I believe the only change that I need to make is to check the BEx reporting flag in the ODS. Is this correct and are there any possible limitations with this approach? Thanks

[Former Member · Accepted solution]

Hi Niten,

I read in the document...

"If the SnapShot Scenario is chosen to reduce the Query-Runtime it should be taken in account that for recovery reason and for the ability to retrace the data it is only advisable to run an InfoCube with non-cumulative keyfigures with all the movements in parallel for a certain timeframe. For the administrator it is much easier to avoid, find and repair inconsistencies in the data. Inconsistencies could happen if data in the PSA is deleted and the update-/ transferrules do not fulfill all the EndUser requirements or the coding is just wrong. A reinitialization of all the past data could be necessary. In the SnapShot Scenario the past data is nowhere stored."

Hope it helps!

Bye,

Roberto

[Former Member · Accepted solution]

Hi Roberto,

Thanks for that:

Therefore I do not need the cube and can if necessary just report off the ODS by checking the BEx setting

Message was edited by: Niten Shah

[Former Member · Accepted solution]

Yes,

but keeping in mind warnings previously highlighted !

Bye,

Roberto

[Former Member · Accepted solution]

Thanks Roberto,

At my age senility is settling in. Can you remind me of the warnings

[Former Member · Accepted solution]

Good one, Niten !

The warning is related to lost ability to retrace the data in case of inconsistencies (since you will not have anymore movement details at your disposal as if you maintain also a cube!)

Again,

Roberto