on 05-19-2012 2:05 PM
Hi
I have a simple allocation script which works fine.
*SELECT(%GI_RU%,"[ID]",RU,"[PRIM_SEG] = 'GI'")
*XDIM_MEMBERSET RU=%GI_RU%
*XDIM_MEMBERSET ACCOUNT=GAK
*RUNALLOCATION
*FACTOR=1
*DIM TIME WHAT=2013.INP; WHERE= BAS(2013.TOTAL);
*ENDALLOCATION
Now I want to make the year dynamic. I tried different things with the %YEAR% option but nothing seems to work.We are on BPC10.
Can anybody help ?
Rgds
Can you please be more specific: what means dynamic? Do you want to get Year from user input or based on some property changed annually or something else?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Tho,
- If you want to build your time memberset based on year property of category dimension, you can write a SELECT statement , something like -
*SELECT(%TIME_YEAR%,YEAR, "Category", "[ID] = '<Category Dimension Member'"
This will fetch the year from year property for the defined category dimension member and store it in TIME_YEAR. You can then refer to this variable for your calculations.
- %YEAR% will give you current year and you can use this in your *DIM instruction.
So, your *DIM instruction can look like -
*DIM TIME WHAT=%YEAR.INP; WHERE= BAS(%TIME_YEAR%.TOTAL);
Hope it helps!!
User | Count |
---|---|
11 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.