Using property value in Allocation Logic.

[Former Member]

Hi All,

Can we use a property value from one dimension as ID for different dimension in the Allocation Logic?

I have a category Actual which has a value of 2011 in the property YEAR.

I need to use 2011 in DIM TIME statement.If somehow i can get the 2011 value into a variable then i can use that variable in the DIM TIme statement.

EX:

*SELECT(%TIMEYEAR%,"ID",.....................................) (This is where i need help ..in writing the statement)

DIM TIME WHAT = [YEAR]=%TIMEYEAR%; WHERE = %TIMEYEAR%(1).INP; USING = %TIMEYEAR%(1).INP;

This would mean:

DIM TIME WHAT=[YEAR]=2011; WHERE=2012.INP; USING=2012.INP;

Can we get this to work in Allocation Logic?I need to know if i can get the value of the property into the variable?

Any help is appreciated.

Thanks,

KK

[Former Member]

Hi

I believe using the category property "YEAR" in the logic may not be a good idea. In case of next year, you need to change the property value "YEAR" to 2012...... and so on.

If you want to bring the current year as variable you can use system variable %YEAR%

%YEAR% - Returns current calendar year

DIM TIME WHAT = YEAR=%YEAR%; WHERE = %YEAR%(1).INP; USING = %YEAR%(1).INP;

Try and let me know

Thanks

[Former Member]

Hi,

Try out this select statement,

*SELECT(%TIMEVAR%,"[YEAR]",CATEGORY,"[ID]=ACTUAL")

%TIMEVAR% is the variable

YEAR is a property of Category dimension

ACTUAL is a member of Category dimension

Regards,

Ramanathan

Edited by: Ramanathan_S04 on May 24, 2011 11:05 AM