Building BI to BPC Reconciliation report in BPC side

[Former Member]

All,

I am working on BI/BPC Reconciliation report in BPC side. So far I  have created two connections (one Local BW and one BPC model) to show BW and BPC output side by side. BW and BPC Account is in Row axis in both of  these reports.

I am facing two constraints:

• BW account and BPC account IDs are different. only difference is BW IDs are having 3 leading zeros.
• Row axis disabled in both reports. may be row axis not shared due to local connection.

So in the present form , I am planning to create a new hierarchy in BPC for Account member to maintain all BW accounts of BW. After sorting by Account row in both reports, all accounts will be same corresponding to both reports while displaying.

So variance will be calculated.

My present report format-

My question is can you recommend any better approach and if  my approach is ok ?

One more question is can I merge BW and BPC report row like below and is this approach feasible in my current scenario?

Please share your thoughts and suggestions. Thanks!

Regards

Veera Kommineni

[sap_user62]

Hello,

You could use 2 tabs, one for EPM data and one of BW data local connection.

You need not create another hierarchy, just create a local member trimming the additional zeros from BW GL Accounts in BW tab.

Add vlookup to each sheet, to  search for values for the corresponding GL Accounts.

This has to be done on both sheet so that you do not miss any account which is present in only system.

I am not sure if you can share axis with different models in 10.0.

Ed.