Validate BPC data with ECC data

[Former Member]

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

[former_member200327 · Accepted solution]

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?

[Former Member · Accepted solution]

Sorry guys for late reply..

I am happy that so many people are involved to solve this issue..

I am hearing this requirement from different client 3rd time and i guess you too ..

BPC owns by the finance users who have access to SAP ECC and BPC excel..so they are not completely comfortable to compare with BW data only..

Garesh & others ->

BPC and BW are on same box..

Is it possible using ABAP code to read value of f.01 ( ie total asset) as shown and write into one dummy bpc member ?

Thanks guys..

[former_member200327 · Accepted solution]

You don't have to write anything into BPC.

First, you have to find a BAPI or some RFC enabled function in ECC that can bring back that Total. You you can't find such you have to develop it.

Then you can write a BPC report and in SQE BADI call that function above. Show both in the report.

[Former Member · Accepted solution]

Great thanks!!

[Shrikant_Jadhav]

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

[Former Member]

First 2 option is not solution..

Option 3 - Is there any specific BADI to pull total value separately and load in dummy member in BPC ?

[Shrikant_Jadhav]

Hi,

There is no specific BADI, you can write custom BADI to achieve this or  just read data from BPC & BW cube in BADI and compare it.

Shrikant 

[bishwajit_das]

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

[Former Member]

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

[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