Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    May 20, 2015 at 08:22 AM

    Hi,

    "Employee dimension has property NO_DAYS" - it's a bad idea to use property to store some value. You can't use it in the REC expression directly, only using slow FOR/NEXT!

    Simply create some account NO_DAYS and fill it with the required values. Then use this account in script logic calculations.

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • May 20, 2015 at 08:02 AM

    Hi,

    I think you are missing select statement to read attribute of Employee.

    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded