Run Allocation : Making dynamic using Dimension Property

[arun_varghese]

Hi All,

I am working in BPC 10 NW

We have a specific requirement for RunAllocation logic

We have 2 dimensions named H_COST_CENTER and H_FUNC_AREA. Both these dimensions are linked via a Property named 'FUNC_AREA'  in the H_COST_CENTER dimension.

We need to allocate X value from Cost Centres CC1 to CC12, CC13,CC14

In our Run Allocation Logic, we need to make the H_FUNC_AREA dynamic.

Sender CC is defined by %Q1% and Receiver CC by %Q3%

We need to know how the DIM H_FUNC_AREA should be written;  where we tried to link to the property of Cost Centre dimension

Tried the bekow statement in the logic, but failed

*DIM H_FUNC_AREA WHAT = %Q1%.[FUNC_AREA] ; WHERE = %Q3%.[FUNC_AREA] ; USING = <<<;

*FOR %Q1% = CC1
*FOR %Q2% = 2014.01
*FOR %Q3% = CC11, CC12, CC13

*RUNALLOCATION
*FACTOR = USING

*DIM TIME WHAT=%Q2%; WHERE = <<<; USING = <<<;
*DIM H_FUNC_AREA WHAT = _________ ; WHERE =  _________ ; USING = <<<;

*ENDALLOCATION

[Former Member]

Hi Arun,

Vadim is correct...The above syntax wont work....and as per my knowledge we cant use dimension property values in script logic.

If your hard coding the costcenter, you might as well hard code the value of FUNC_AREA in  the allocation script. Do you have one to many mapping between costcenter and functional area?

Regards,

JP

[former_member186338]

"we cant use dimension property values in script logic" - ups, too strong

[Former Member]

Ohhhh...reaĺly?☺ but the fact....Dont you agree?

[former_member186338]

We can use property values in many statements of script logic, but not the same way

In REC we can use property value to read from specific member stored in property (using LOOKUP) and write to specific member stored in property:  SOMEDIM1=SOMEDIM.PROPERTY.

In RUNALLOCATION we are limited to fixed selection of source and destination members by property.

Vadim

[former_member186338]

Hi Arun,

For sure you can't use the syntax like:

*DIM H_FUNC_AREA WHAT = %Q1%.[FUNC_AREA] ; WHERE = %Q3%.[FUNC_AREA] ; USING = <<<;

In general you have to use WHAT and WHERE selected by property (please read help about *RUNALLOCATION).

WHAT=[SOMEPROPERTY]="%SOMEVAR%"

where %SOMEVAR% - variable containing the required property value!

Vadim

[arun_varghese]

Hi Vadim,

Thanks for the input.

I am aware that we can refer to dimension property of H_FUNC_AREA in the below expression. However, is it possible to refer to another dimension property, like here WHAT should depend on the FUNC_AREA property value defined in Cost Center dimension.

*DIM H_FUNC_AREA  WHAT=[SOMEPROPERTY]="%SOMEVAR%"

[former_member186338]

"However, is it possible to refer to another dimension property"

No, this is not possible! No way!

Vadim

[Former Member]

Hi Arun,

You can use values form Property of another Dimension, but indirectly.

You should first create a variable populated by those values using *SELECT for example. Next, you can use that variable in RUNALLOCATION restricting any other Dimension.

I know that this is too generic, so not sure if it helps you to resolve the initial issue, but it answers you last question.

Regards,

Gersh