BI FI and Cost Centre Reconciliation

[Former Member]

Hi

I have a requriement to create a GL reconciliation report between Finance and Cost centre data, i have a multi sitting over the relevant cubes and the data is coming through.

The report is as follows

|_FI Total__|___Cost Centre Total__|__Difference_(should = 0)

GL Account | | |

For the cost centre data the report should bring through the data where the cost element = GL account in the row,

ie GL Account - 60000

FI Total - GL Account - 60000

CC Total - Cost Element - 60000

Difference - FI - CC

Any ideas on how i can do this or if this is possible?

Thanks

Josh

[Former Member]

Hey Josh,

Are able to create the report which u mentioned in this thread? I have the same report but the difference is coming for few G/L accounts. Do you know where it would be going wrong?

Please reply immediately.

Thanks

[Former Member]

Hi Harshal

Yes i was able to create this report, i had to create an infoobject ZFI_GLCE with 0GL_ACCOUNT as a ref. characteristic.

Then i created a cube and had transformation going from YCOOM_C02 (CO-OM: Costs and Allocations (Delta Extraction)) to the cube where i mapped the Cost Element to ZFI_GLCE and then also had another transformation from YFIGLO02 (General Ledger: Line Items) to the cube mapping the GL Account to ZFI_GLCE.

Could you further explain the problem you are having with the GL Accounts?

Josh

[Former Member]

Hey Josh,

Thanks but I already have a report, i dont have to create a new 1. My report is comparing GL account's amount in FIGL cube with Cost Elements amount in CO cube. I am getting some difference in values for few GL accounts, logically it shud be same.

But I am not knowing why is the difference coming. In your case are able to get right output, I mean is differece = 0?

-Harshal

[Former Member]

Created Custom infoobject.

[Former Member]

hi ,

You have to create a cube on one set of data and map in updaterules like

g/l account from gl to cost element in CCA.

The build a multi cube on new cube and existing cubes (either cca or GL)

regards,

sekhar

www.sapadvisors.com