Using property value in Allocation Logic.
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.
*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.