Replication APO Planning Data from LiveCache To HANA for Analysis

[Former Member]

Applies to:

SAP SCM 7.2 Support Pack 8 and HANA 1.00.74.390550 (NewDB100_REL)

Summary

This document gives an insight into configuring function to replicate planning data (transaction data) from your SAP APO Live Cache to an SAP HANA system through a secondary database connection. Download and Install the HANA content model for Business Analysis.

Master data is replicated using SAP Landscape Transformation (SLT) but that is not possible for planning data as it does not store in database tables, but in SAP liveCache.

We run the reports or schedule the delta to push the planning data in Demand Planning (DP) and Supply Network Planning (SNP) to be available HANA system for Business to analysis.

Author:          Santanu Bose

Company:      Wipro Ltd.

Created on:    26 July 2014

Author Bio

Table of Contents

Step 1:  Install HANA DB Client in APO system………………………………………….3

Step 2: Setup Secondary DB Connection with HANA…………………….………….…3

Step 3: Set up a replication model and activate it.………………………………………4

Step 4: Run Full Replication..……………………………………………………..…………5

Step 5: Run Full Replication and Scheduling………………………………….…………6

Step 6: HANA Content Model installation………………………………………………...9

Step 7: Run Business Analysis on data in HANA………………………………….…..11

REFERENCE………………………………………………………………………………….12

Disclaimer and Liability Notice…………………………………………………………….12

Step 1:  Install HANA DB Client in APO system.

Need to install HANA Database client in SCM (APO) System.

Step 2: Setup Secondary DB Connection with HANA

Create Secondary DB connection   (/ndbco)

Step 3: Set up a replication model and activate it.

Create Replication model (SAPAPO/REPL_MOD_VIE)

Define the Key Figures:

Activate Replication Mode (/n/SAPAPO/REPL_MOD_MNG)

Upon activation the tables should be created in HANA database.

Step 4: Run Full Replication.

Replication of Planning Data to SAP HANA (/SAPAPO/REPL)

Step 5: Run Delta Replication and Scheduling

Schedule delta replication (/SAPAPO/REPL_DELTA )

The table’s data should be available in HANA database.

Step 6: HANA Content Model installation

Download HANA Content Model (/SAPAPO/REPL_REPLICATION_MODE)

Install the HANA Content Model using import function in HANA Studio

Step 7: Run Business Analysis on data in HANA

Run analysis on the data in Calculation view been installed.

REFERENCE

http://help.sap.com/saphelp_apo700_ehp03_on_erp/helpdata/en/94/ae821e58fa4dbdac0c71028b943696/conten...

http://help.sap.com/saphelp_apo700_ehp03_on_erp/helpdata/en/bb/b2d7873071401e902a21e1e64a055b/conten...

Disclaimer and Liability Notice

This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not

supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.

SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document,

and anyone using these methods does so at his/her own risk.

SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or

code sample, including any liability resulting from incompatibility between the content within this document and the materials and

services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of thisdocument.