Skip to Content
0
Former Member
Apr 15, 2014 at 07:12 AM

runallocation get member of current row

39 Views

Hi experts,

i have a problem about how to fetch member of current row.

as example:

- master data of JobGrade = JG1, JG2, JG3, JG4, JG5

- the relationship between Empl & JobGrade is 1:1

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*SELECT(%YEAR%,YEAR,CATEGORY,[ID]=%CATEGORY_SET%)

*XDIM_MEMBERSET JOBGRADE AS %JG_VAR% = bas(JG_TOTAL)

*FOR %TIME_LOOP% = %TIME_SET%

*FOR %JOBGRADE_LOOP% = %JG_VAR%

*RUNALLOCATION

*FACTOR=USING

*DIM INTERCO WHAT=NO_INTERCO; WHERE=>>>; USING<>NO_INTERCO; TOTAL=<<<;

*DIM JOBGRADE WHAT=%JOBGRADE_LOOP%; WHERE=<<<; USING=NO_JOBGRADE; TOTAL=<<<;

*DIM JOBGRADE WHAT=bas(JOBGRADE); WHERE=<<<; USING=NO_JOBGRADE; TOTAL=<<<;

*DIM TIME WHAT=%TIME_LOOP%; WHERE=<<<; USING=NO_TIME; TOTAL=<<<;

*ENDALLOCATION

*NEXT

*NEXT

*COMMIT