Experts,
We have a bad design of the BCS Cube for couple of our legal entities - The reason, i am saying it is a bad design is because we load the data (from a non SAP Source - Flat File) at Group Account Number into this cube and then do the FCT in BCS for those entities.
On account of which, when we drill down from the BCS Cube to the BW Cube(Go to Query), we see a disconnect between the values in the BCS Total Cube to that of the BW Cube( to which the values at the G/L Account level are loaded).
What are the possible ways to take care of this? - Is there anyway we can extract the rate being used after the FCT is run in BCS and then apply it to the individual accounts values in the BW Cube.
All answers would be duly appreciated and rewarded with points.
Thanks,
Nandita