SAP MDG · COMMUNITY
How do I create HANA-based analytics for SAP Data Replication in SAP MDG?
Use the SAP MDG HANA-based analytics procedure to build calculation views for replication monitoring and KPI analysis. The guide applies to MDG 7.0 SP02 and higher, requires HANA-based analytics to be enabled first, and uses Change Request plus replication data to create two calculation views and an XSOData service.
Use the SAP MDG HANA-based analytics procedure to build calculation views for replication monitoring and KPI analysis. The guide applies to MDG 7.0 SP02 and higher, requires HANA-based analytics to be enabled first, and uses Change Request plus replication data to create two calculation views and an XSOData service.
Use this procedure to build SAP HANA-based calculation views for analyzing SAP MDG data replication. The guide applies to MDG 7.0 SP02 and higher and is intended to determine whether replication happens according to agreed KPIs. It also states that HANA-based analytics must be enabled first and configured for the relevant deployment scenario.
Process flow
- Use this procedure to build SAP HANA-based calculation views for analyzing SAP MDG data replication.
- Enable HANA-based analytics for SAP Master Data Governance.
- Configure it for the applicable deployment scenario: Replication Scenario or Integrated Scenario.
- Trigger replication through `DRFOUT` or the Membership API when relevant to the analysis.
- Create calculation view `DataReplication`.
- Create calculation view `DataReplicationQuery`.
- Create the XSOData service.
- Use `DRFD_OBJ_REP_STA` as the main replication-status source table and enrich it with business-system and object-type data.
Customizing
Trigger data replication by calling the outbound implementation; supports initialization and collected change pointers.
HANA Development Perspective → Project Explorer
Create the project structure for the replication analytics content, including the `odata` folder.
Project folder → `odata` subfolder
Expose `DataReplicationQuery` as an XSOData service.
Referenced tables
| Object | Purpose |
|---|---|
DRFD_OBJ_REP_STA | Source table for replication status information, including Change Request, Run ID, replication status, application-log handle, and message GUID. |
MDG_BUS_SYS_TECH | Source table for business-system technical information such as logical system and RFC destination. |
MDGI_OTC_BS | Source table for Business Object Type information. |
MDG_BUS_SCYS_ATTR | Source table for replication attributes such as communication channel and key harmonization. |
ILLUSTRATIVE ABAP SAMPLE
DataReplicationQuery calculated column example
Source-supported sample logic for the calculated column `IsFailed` in the query view.
1if("StatusName"='SE' OR "StatusName"='PE','X',' ')The remaining configuration, implementation details, and testing guidance continue from this answer more…
Related questions and keywords
Alternative questions
- What is this guide about?
- How do I create HANA-based analytics for SAP Data Replication?
- Which releases are applicable?
Possible questions
- What information is used for MDG replication KPIs?
- Why create replication analytics?
- What must be configured before creating the views?
- Does MDG HANA analytics need to be enabled first?
- How can data replication be triggered?
- What is DRFOUT used for?
- What is the Membership API used for?
- When does MDG call the Membership API?
- Which table stores replication status information?