Skip to Content

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

UJK_VALIDATION_EXCEPTION:Member "XXX" not exist

Hi,

I am looking for logic to calulate the below requirement.

Employee dimension has property NO_DAYS(used to capture no of days employee work in year)

I need to calculate effective FTE

Effective FTE = NO_DAYS/365

Example: NO_DAYS = 182

Effective FTE = 182/365 = 1/2 = 0.50 FTE.

I want to use script logic for calculation.

*WHEN EMPLOYEE

*IS *

*REC(EXPRESSION = %VALUE%*([EMPLOYEE].[NO_DAYS])/365)

*ENDWHEN

I am getting this error

UJK_VALIDATION_EXCEPTION:Member "NO_DAYS" not exist

Tags:
Former Member
Former Member replied

Hi Tej,

If your planning to use HR master data flat file to upload as Employee master data. You can use the same file to upload the no. of days as transaction data to an account(NO_OF_DAYS for example).

Just create a new transformation file wherein you will map something like below

EMPLOYEE = *COL(1)

SIGNEDDATA=*COL(2)

ACCOUNT=*NEWCOL(NO_OF_DAYS)

Likewise hardcode the other dimensions using *NEWCOL and you can upload the values easily.

Hope it is helpfull...

Regards,

Priyanka

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