Hi,
I'm trying to figure out a way to allocate constant values (revenue) throughout the lower levels of a hierarchy (i.e levels that have no relationship with revenue), while at the two highest levels of the hierarchy I would like revenue to act as a normal roll-up measure. The powerplay transformer manual tells me not to use the allocation option for this, but it forgets to mention what I need to do instead. I can always opt for an "external rollup" where I provide the revenue figures for each node separately, but I'm posting the question here to see if there are alternative, more efficient, solutions.
Thanks in advance.
Rob
I'm trying to figure out a way to allocate constant values (revenue) throughout the lower levels of a hierarchy (i.e levels that have no relationship with revenue), while at the two highest levels of the hierarchy I would like revenue to act as a normal roll-up measure. The powerplay transformer manual tells me not to use the allocation option for this, but it forgets to mention what I need to do instead. I can always opt for an "external rollup" where I provide the revenue figures for each node separately, but I'm posting the question here to see if there are alternative, more efficient, solutions.
Thanks in advance.
Rob