If you are unable to create a new account, please email support@bspsoftware.com

 

measure allocated as constant value throughout some, but not all, of dimension

Started by RB01027, 02 Jul 2006 03:12:16 AM

Previous topic - Next topic

RB01027

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