Skip to Content
0
Former Member
Jun 08, 2016 at 01:51 PM

Using property in Allocation

164 Views

Hello All,

I need to use the property to derive the value for USING clause in the allocation script. I read that using property in allocation works in Microsoft version and I tried in NW but it is not working. Following is the statement in the allocation script which I am trying to get the value from TIME dimension property LAST_PERIOD.

My allocation percentages are stored in the last month (Dec) of the year. If I run the following alloc script for 2016.01, 2017.01 then it should use percentages USING = 2016.12, 2017,12 for that year. Note: LAST_PERIOD property has values 2016.12 for all the 2016 periods.

*DIM_NONAGGR TIME WHAT = %TIME_SET%; WHERE<<<; USING = %LAST_PERIOD%

I appreciate your reply.

Regards,

Saila