Skip to Content
0
Former Member
Jul 21, 2010 at 06:18 PM

Use of MEASURES dimension in a RUNALLOCATION in a script logic

29 Views

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