Use of MEASURES dimension in a RUNALLOCATION in a script logic

[Former Member]

Hi everybody,

We are trying to use MEASURES dimension inside a RUNALLOCATION in a script logic, because we need to work with the information at a YTD element

Example:

It works:

*XDIM_MEMBERSET C_CATEGORY=%C_CATEGORY_SET%

*XDIM_MEMBERSET TIEMPO=%TIEMPO_SET%

*XDIM_MEMBERSET PRODUCT=BAS(TOT_PRODUCT)

*XDIM_MEMBERSET MARKET=BAS(TOT_MARKET)

*RUNALLOCATION

*FACTOR=USING

*DIM ACCOUNT WHAT=Cost; WHERE=Import; USING=Units;

// *DIM MEASURES WHAT=PERIODIC; WHERE=PERIODIC; USING=YTD;

*DIM CLIENT WHAT=CLIENTE_NA; WHERE=>>>; USING=BAS(TOT_CLIENT);

*ENDALLOCATION

*COMMIT

It doesn't work:

*XDIM_MEMBERSET C_CATEGORY=%C_CATEGORY_SET%

*XDIM_MEMBERSET TIEMPO=%TIEMPO_SET%

*XDIM_MEMBERSET PRODUCT=BAS(TOT_PRODUCT)

*XDIM_MEMBERSET MARKET=BAS(TOT_MARKET)

*RUNALLOCATION

*FACTOR=USING

*DIM ACCOUNT WHAT=Cost; WHERE=Import; USING=Units;

*DIM MEASURES WHAT=PERIODIC; WHERE=PERIODIC; USING=YTD;

*DIM CLIENT WHAT=CLIENTE_NA; WHERE=>>>; USING=BAS(TOT_CLIENT);

*ENDALLOCATION

*COMMIT

How can we do it? Is possible to use Measures dimension?

Any idea out there?

Kind regards

Albert Mas

[esjewett]

Hi Albert,

I believe you are correct that using MEASURES in this way is not possible. Depending on whether you have data in future periods, you may just be able to use the time dimension instead of the measures dimension:

*DIM TIME WHAT=2010.AUG; WHERE=2010.AUG; USING=2010.TOTAL; 

You could also manually maintain a property and select on the property to do the same thing, which would allow you to exclude future periods.

Another option might be to make your Units account a balance sheet account, which should make it always behave as a YTD value, or create a second UNITS_YTD account as a balance sheet account and populate it with the Units YTD value using script logic before running the allocation, then use the UNITS_YTD account as your allocation driver.

Ethan