Skip to Content
avatar image
Former Member

Validate BPC data with ECC data

Hi Experts

We load data daily from ECC -> BW -> BPC

Now user wants to verify that data in BPC and ECC are sync ( using some automatic process - not drillthrough ) after each load.

ex: Data loaded for Month - 2015.Jan.. ( lets say total asset value for all entity = $100 in ECC and they just want to make sure in BPC this value is also $100)

Is there any BADI to pull this $100 value only in some Dummy member in BPC and run controls to check Dummy member = Total asset value ?

I hope my question was clear

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 10, 2015 at 04:36 PM

    No, this is absolutely not clear.

    Does your user trust data in BW or not? If they do, then just compare data in BW cube and BPC with plenty of options to do this.

    If your user doesn't trust data in BW then question is if your BW and BPC are on same box or on different?

    If they are on same box then most probably it has an RFC to ECC and you can use something to get data from ECC to compare. If they are on different boxes then main question is: does BPC box has RFC connection to ECC box?

    See how many additional questions your issue brings?šŸ˜‰

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 03:39 PM

    Any lead will be helpful..or any other alternative ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      You need to pull a report in ECC and then in BPC to compare values, once the tests are done and the values are the same then you should assume the loading is correct. you need to do multiple tests to double check.

      If will be pointless to use a BADI to pull in the total into BPC, then you need to chec if the total is correct as well? how are you going to do that? by creating a report in ECC.

      Andy

  • Jan 08, 2015 at 06:46 PM

    Hi,

    For reconciliation of data you can try following options

    1) Create a local connection to BW cube and a planning and consolidation connection to BPC cubeĀ  using EPM Add-in and get the data from both the cubes and reconcile.

    2) Query directly on BPC multiprovider using your BI Bex Tools/BI Analyser and compare these results with your actual BW data.

    3) Write customĀ  BADI

    For more help go through the following links

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      There is no standard BADI to compare the ECC/BW data with BPC.

      What I would suggest, you can use the END_ROUTINE BADI in BPC where you will have to write a logic to check the condition for the " total asset value for all entity = $100 for the month 2015.Jan ".


      According after the data is verified, it will be loaded to BPC. Just for your information you have to mention the BADI filter in the Transformation file.


      Wish that helps.


      Regards,

      Bishwajit