SAP Knowledge Base Article - Public

2658507 - WFA on HANA Cube Build Process is failed with Error Message - "attribute value is not a number;decfloat"

Symptom

WFA on HANA Cube Build Process is failed with Error Message - "attribute value is not a number;decfloat".

Environment

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"

Resolution

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.

Keywords

  • WFA on HANA
  • Build Fact Data & Cube
  • Cube Build
  • Attribute Value
, KBA , LOD-SF-WFA-ADM , Admin Tools , Problem

Product

SAP SuccessFactors HCM Core all versions