Skip to Content
0
Former Member
Feb 25, 2011 at 12:07 PM

Key figure summation for KF IN different cube of a MP

32 Views

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