SSM KPI weighted consolidation

[vctorabad_garcasosa]

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

[Former Member]

For a single dimension (e.g. LOCATION)

sel LOCATION *

set mea3 nocon

set mea1 nocon

set mea2 nocon

calc mea3 = mea1 * mea2 / mea2 in COMPANY TOTAL_COMPANY full

I have not done this for multiple dimensions so you'll need to experiment with the syntax. I would guess something like.

calc mea3 = mea1 * mea2 / mea2 in COMPANY TOTAL_COMPANY GEOGRAPHY TOTAL_GEOGRAPHY full