Skip to Content
0
Jun 28, 2016 at 10:53 AM

How to design a bex report on Virtual Cube Data and Flat File Data ?

30 Views

Dear Guru's

I have Requirement of designing a Bex report for Balance Sheet.

For this , Initially the i have activated G/L (New): Balance Sheet and Profit a - Virtual cube and i maintained Hierarchy (0GLACCTXT ) - financial version statement in ECC , As per ECC hierarchy . i mapped and i have done the report .

All things are fine.

But now Client Requires in the Same report Flat FILE data things has to Come and that flat file records are nothing but opening balance,

there they will see the Opening Balance things in one columns , Second Column transaction records (ECC - Virtual Cube) and another column is closing balance like that.

For that i have Created a info cube and i maintained same info objects which are there in virtual cube and i created a multi provider by combining Flat file cube and Virtual cube.

how to create Key Figure columns

which are opening Balance are Flat File data,

Current balance are ECC data...

Please Guide me Guru's

Thanks and Regards,

Syam.