Hi all,
Got a little issue with a calcuated measure I'm doing in Transformer.
This calculation is only applicable at the year level as one of the measures used in it is rolled up (averaged) to the year level. I go down to the month level in my cube. I obviously then only want this measure to be applied at the year level (ie. allocated?), with NA's appearing, for example, when user goes down to mth.
Thought maybe allocating measure might work, do a constant year value through mthly cells, but allocation tab is disabled.
any ideas on how best to implement?
thx much,
Steve
Got a little issue with a calcuated measure I'm doing in Transformer.
This calculation is only applicable at the year level as one of the measures used in it is rolled up (averaged) to the year level. I go down to the month level in my cube. I obviously then only want this measure to be applied at the year level (ie. allocated?), with NA's appearing, for example, when user goes down to mth.
Thought maybe allocating measure might work, do a constant year value through mthly cells, but allocation tab is disabled.
any ideas on how best to implement?
thx much,
Steve