cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data Sync Check Automation between ECC vs BPC

former_member212236
Active Participant
0 Likes
603

Hello All,

I have got the below scenario where I am looking for the options which I can utilize to automate the task of checking whether the data between ECC and BPC are in sync. Kindly advise if you have come across a similar scenario in your path so far and also your valuable comments on how we can approach this requirement.

We are using BPC 10.1 version and both the BW and BPC models reside in the same system.

Data Flow: ECC to BW to BPC

Requirement:

When a business user creates a transaction today in the ECC system, then the same data is expected to be visible in the BPC reports. But, sometimes, due to a data load failure or due to an incomplete job, there is a possibility that the data posted in ECC is not yet arrived into BPC or lost due to some issues leading to a mismatch of data between ECC vs BPC report.

The user now would like to have some automation in place that they can check on a daily basis at the start of their day at work to see whether the data is in Sync between ECC and BPC.

Current Scenario:

The Business had created a report at the ECC side and another report at the BPC side which they refresh daily and compare to ensure that the data matches.

Kindly share your thoughts.

Regards,

Vinoth

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Likes
former_member212236
Active Participant
0 Likes

Hello Vadim,

Thank You so much for your response and for sharing the links.

Regards,

Vinoth

former_member186338
Active Contributor
0 Likes

vinoth.v

Please accept the correct answer!

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Likes

There is no simple way to compare data in ECC and BPC.

The data load is a complex process with transformation and conversion on BW side and during BPC load. There is no magic solution to check values. In some cases drill down to ECC can work...

former_member212236
Active Participant
0 Likes

Hello Vadim,

Thank You for your response.

Could you please help me understand what are you referring to when you say "In some cases drill down to ECC can work."?

Regards,

Vinoth