Aggregation of percentage figure as key figure

[alexander_mocanu2]

Hello everybody, I need your help please!

I've create a new cube containing customerID and a percentage key figure representing the national part af a regional customer and bound it succsessfully to the reporting multicube.

I can calculate national/regional gross and net and any other key figure as percentage of the total of the respectiv key figure, and it works fine, but only as long as the customer is in the drill down.

If I want to see aggregate figures for regions, for instance, eliminating customer from drill down, it cumulates the percentages per region and calculates with this sums. The result ist catastrophic, since the sum of percentages per region is like 980%, for instance!!!

How can I bring about to sum the regional/national part and not the percentage key figure?

Thanks for any help

Alexander

PS I can provide screenshots descibing the problem

[Former Member · Accepted solution]

use function %RT and %GT

[alexander_mocanu2 · Accepted solution]

thanks Tripple k !

I don't think it's what I need.

Example:

Keyfigure percent is given for each customer.

I calculate "part" equals "gross" * "percent" / 100

I've got the following situation:

customer region percent gross part

C1 N 50 289000 144500

C2 W 75 536000 402000

C3 W 80 485000 388000

C4 N 90 368000 331200

C5 E 85 102000 86700

C6 E 95 251000 238450

Sum 2031000 1590850

If I eliminate customer from the drill down I get:

region % part gross part

N 140 657000 919800

W 155 1021000 1429400

E 180 353000 635400

Sum 2031000 2984600

which is wrong since it cumulates percentage and then calculates "part"

What I expect is:

region percent gross part

N x 657000 475700

W x 1021000 790000

E x 353000 325150

Sum 2031000 1590850

I expect the sum per region of calculated "part" for each customer.

Do you have any idea?

[Former Member · Accepted solution]

hello Alexander

In the Calculated key figure property select before aggregation.

Thanks

Tripple k

[alexander_mocanu2 · Accepted solution]

hello Tripple k,

very good idea!

The problem is, I cann't select "before aggregation" since this feature is not activ.

I suppose, it's because percentage key figure and the other key figures are in different cubes. Is my assumption correct?

regards

Alexander

[alexander_mocanu2 · Accepted solution]

I've got it!

The formula calculating percentage key figures must not contain restricted key figures. Othewise "before aggregation" will not be active!!!