Skip to Content

Data Sync Check Automation between ECC vs BPC

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 03, 2019 at 08:31 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 02, 2019 at 06:53 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.