Calculated Measure on SSAS 2005

Dear All,

I have a problem when I made calculation on SSAS 2005. I have two dimensions such as Department and Parameter where 1 Department has several Parameters. Each Parameter has point measure (Total Point Parameter) and bobot measure in percent (Bobot Parameter). The subtotal of Total Point Parameter is sum of Total Point Parameter for parameters in 1 department and the subtotal of Bobot Parameter is sum of Bobot Parameter for parameters in 1 department which the result will be 100%. I want to make a calculated measure named Total Point Department that I can get the result by multiplying Total Point Parameter with Bobot Parameter. But for the subtotal of that calculated measure, the value should be sum of Total Point Department for parameters in 1 Department. I attach the layout so you can have a good understanding to my problem.

Department Parameter Total Point Parameter Bobot Parameter Total Point Department

KREDIT FPD 80.56 25.00% 20.14

NBP 95.49 25.00% 23.87

OVERDUE BPKB 96.17 10.00% 9.62

OVERRIDE SCORING 110.00 10.00% 11.00

POOLING ORDER 35.00 30.00% 10.50

Total 417.21 100.00% 417.21 --> it should be
75.13 AR AR ALIR ACTUAL 90.73 30.00% 27.22

AR ALIR ACTUAL VS TARGET 1.00 20.00% 0.20

AR LANCAR ACTUAL 200.00 30.00% 60.00

AR LANCAR ACTUAL VS TARGET 222.22 20.00% 44.44

Total 223.25 100.00% 223.25 --> it should be
131.86 Grand Total 640.46 200.00% 1280.92

This is the MDX script for Total Point Department:

[Measures].[Bobot Parameter] * [Measures].[Total Point Parameter]

Can you please help me? Thanks in advance.

Regards,

I have the same issue, have you been able to solve your problem?

|||

Have you tried setting this up use a measure expression instead of a calculated measure?

I think this will make the multiplication happen at the leaf level and then the normal aggregation will kick in.

Otherwise you could try scoping your calculation at the leaf level.