Skip to Content
0
Nov 11, 2014 at 02:42 AM

SSM KPI weighted consolidation

29 Views

Hello,

I am using SSM 10.1 and I want to create a measure (mea3) from another measure (mea1) with consolidation among dimensions weighted by other measure (mea2).

The value of mea3 must calculated using the following formula

mea3 = mea1 * mea2 / sum(mea2)

where sum(mea2) is the total value for all the dimensions of mea2

e.g.

dimension Company

COMP1 COMP2 COMP3

mea1 10 10 10

mea2 20 30 50

mea3 2 3 5

I tired to modify the CONSOLINFO document in order to call a custom made procedure but I am not pretty sure about how to do it.

Kind regards