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