WFA on HANA Cube Build Process is failed with Error Message - "attribute value is not a number;decfloat".
Workforce Analytics (WFA) on HANA
Reproducing the Issue
- Home > Workforce Analytics > Admin (at the right upper corner)
- WFA on HANA Admin Center > Click on "Build Fact Data & Cube"
- Go To Load Status
- Error Message - "attribute value is not a number;decfloat [here]decfloat(string "COL$0$"),COL$0$ = 'E5847'[string]; checkNull false"
This is a configuration issue - the USERS_SYS_ID field in the EMP_PAYCOMP_RECURRING_T table is set as Primary Person ID, but should be Secondary Person ID.
Please set the USERS_SYS_ID field in the EMP_PAYCOMP_RECURRING_T table as Secondary Person ID.
- WFA on HANA
- Build Fact Data & Cube
- Cube Build
- Attribute Value