UJK_VALIDATION_EXCEPTION:Member "XXX" not exist
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.
*REC(EXPRESSION = %VALUE%*([EMPLOYEE].[NO_DAYS])/365)
I am getting this error
UJK_VALIDATION_EXCEPTION:Member "NO_DAYS" not exist
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)
Likewise hardcode the other dimensions using *NEWCOL and you can upload the values easily.
Hope it is helpfull...