Snapshot in HANA

[former_member182277]

Hello There,

I need to understand how a snapshot for the transnational table can be done in SAP HANA for every month end.

Snapshot can be taken against Cumulative and Non-Cumulative key figure.

Thanks.

Regards,

Neha Singla

[Former Member]

Hi Neha,

There is an excellent blog about Snapshot in Hana by Lars, here is link below

http://scn.sap.com/community/hana-in-memory/blog/2012/12/11/say-cheese-on-taking-snapshots-with-sap-...

How to create and recovery a snapshot in HANA, read page numbers from 17-23 in the given below link.

http://www.saphana.com/servlet/JiveServlet/previewBody/4270-102-1-8994/HANA_SPS07_NEW_BACKREC.pdf

[former_member182277]

Thanks Ravi,

I have already gone through this link.

My requirement is I need to take snapshot of specific tables not for entire thing.

thanks.

Neha Singla

[former_member184768]

Hi Neha,

I would like to suggest creating the snapshots programmatically. Mostly it goes over the last available snapshot + changes during the time period since last snapshot OR sum of the KF till current date.

Both the options are used, depending on the business requirements. If the changes to the transaction data happen to the historical data, then you might have to sum up all the values till the date to correct the snapshots. Otherwise you may have to write the logic for the historical snapshot corrections.

Please provide more details on the requirements and may be we can discuss this in details, if required.

Regards,

Ravi

[Former Member]

Hi Neha,

Did you get solution to take the snapshot for specific table? We do have simillar requirement.

Regards,

Nitin