Live cache backup in HANA

This is document is helpful to Create Live Cache Backup in HANA.

Scenario 1:  APO on HANA database.

Scenario 2: APO on SQL/Oracle database(other than HANA).

Please follow the below steps to create LiveCache backup in HANA:

Step1: Replication Model by using Transaction /SAPAPO/REPL_MOD_VIE.

Click on ‘New Entries’ button

Give name for  Replication Model ID and Description.

Choose Planning Book, Data View, Planning Version, Secondary Database Connection and Selection ID is optional.

Select check box for Delta Replication Relevant Model and Delta Replication Executable.

Scenario 1: Select ‘DEFAULT’ as Secondary Database Connection and this is standard database connection.

Scenario 2: Select Secondary Database connection HD4 which is created by using Transaction DBCO.

Add Key Figures

Step2: Activate Replication Model by using /SAPAPO/REPL_MOD_MNG.

Replication model relevant tables/views will be created in HANA.

Step 3: Check tables/views in HANA which is relevant to replication model.

Step4: Replication of Planning Data to HANA by using Transaction /SAPAPO/REPL and this is full data load.

Step 5: Check full data load in HANA. Demand Plan calculation view under Replication Model.

Can view data in Chart also.

Step 6: Delta Replication of Planning Data to HANA by using Transaction /SAPAPO/REPL_DELTA.

Step 7: Can check delta change in HANA.

Step 8: Create Delta Job by using program /SAPAPO/REPL_REPLICATION_DELTA with periodic.

This Delta job will take care backup in HANA based on periodic intervals.