Hi,
I need to design a report on a Multiprovider. MP is based on two Cube Cube1 and Cube2.
Cube 1 has field item and key figure total quatity. Cube 2 has field item and key figure quatity1.
I need a report which will show
Item quantity1 Total quantity Percentage
Percentage = (quantity1/total quantity)*100.
I am surprised that percentage is X, though other two KF has value.
Is it the case that it is not possible to make summation, subtraction or any opeartion between two KF in different cube.
Could you please guide how to create percentage between two KF in different cube in a MP.
Regards
Deep