Skip to Content
0
Former Member
Apr 16, 2014 at 03:30 PM

Multiprovider - Subtotal calculation

23 Views

Hi expert,

i have this scenario:

Report on a multiprovider based on two cube : cube 1 and cube 2.

Cube 1 and Cube 2 are related but in the last one characteristic is missing.

Example:

Cube1

Customer Group Mater KF1

John sc M1 20

John sc M2 40

Cube1

Group Mater KF2

sc M1 50

sc M2 50

Report on multiprovider:

Customer Group Mater KF1 KF2

John sc M1 20 50

M2 40 50

total 60 120

Why the total of KF2 is 120 and not 100?

thanks

Best Regards.

A.