Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to read Dimesnios ID based on property of another dimension


Hi Gurus,

I have   Dimension1 : EMPLOYEE   Job is property of Dimension: EMPLOYEE

             DImension2: JOB

My requirement is to read the Employees from EMPLOYEE dimension based on the property of JOB .

My Scoping  defined is like this . The code is working fine. But here I hardcoded JOB. I want to process the all the JOBs and read the EMPLOYEE of all the JOBs. Can anyone help me to the syntax of SELECT statement to read the Employees of for each JOB.

*SELECT (%EMP%,[ID],EMPLOYEE,[JOB]= 3001149)

*XDIM_MEMBERSET DATATAG= DT_PEXP_TMAL
*XDIM_MEMBERSET VER = WV1
*XDIM_MEMBERSET CUR= USD
*XDIM_MEMBERSET HRACCT = ALLOC_PCT
*XDIM_MEMBERSET EMPLOYEE = NO_EMPLOYEE
*XDIM_MEMBERSET RECEIVER_CC = NO_RECEIVER_CC
*XDIM_MEMBERSET COSTCENTER = NO_COSTCENTER
*XDIM_MEMBERSET JOB = 3001149
*XDIM_MEMBERSET WBS = NO_WBS
*XDIM_MEMBERSET SKF = NO_SKF


*SELECT(%TM1%,ID,TIME,"[CALC] = N" AND [YEAR]=2015)
*SELECT (%EMP%,[ID],EMPLOYEE,[JOB]= 3001149)


*WHEN HRACCT
*IS ALLOC_PCT
*FOR %TIME% = %TM1%
*FOR %EMPLOYEE% = %EMP%


*REC(FACTOR=1, TIME=%TIME%, EMPLOYEE = %EMPLOYEE%)

*NEXT
*NEXT

*ENDWHEN
*COMMIT

replied

And the script you are testing:

Is incorrect - compare it with my script! FOR is BEFORE XDIM_MEMBERSET!...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question