Skip to Content
0
Former Member
Dec 09, 2007 at 09:50 PM

BI FI and Cost Centre Reconciliation

43 Views

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