Skip to Content

Best way to do snapshot in BW4/HANA or BW on HANA

Feb 26, 2017 at 08:37 AM


avatar image

Good day BI gurus,

I have been searching through the web, but unable to come to a best conclusion to do snapshot using the new BW objects (advance DSO, Open ODS View) or use it together with Calculation View etc).

The scenario would be, I need to store weekly snapshots (happens every sunday at 23:59hrs).

The best way I could think of is by grabbing data from ECC ODP datasource, pump into a Advanced DSO (with Active Table and Change log table), then add in a new column with weekly stamp (2017W01, 2016W02 etc). Then report via Composite provider and further to BW query.

Is there a best practise way of doing snapshot by leveraging the new objects in BWonHANA together with HANA Native views?

Any advice is greatly appreciated.

Many thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers