2507860 - Invalid Member ID error on model creation in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2507860 - Invalid Member ID error on model creation in SAP Analytics Cloud

Symptom

  • Using the split column transformation on a duplicate column works as expected
  • However, when deleting the original column, you cannot create the model and the following error occurs:
    Mapping issues must be resolved in order to create model. The following issues remain:
    The value of the dimension ID is not valid

error_ID.PNG

Environment

  • SAP Analytics Cloud (SAP BusinessObjects Cloud / BOC) 2017.11
  • SuccessFactors SFSF

Reproducing the Issue

  1. Go to Create Model -> App -> Success Factors
  2. Select connection as Your_connection
  3. Select Existing Query radio button (if you already have the query)
  4. Select EmployeeCentralRecruitingMovementSourceQuery1 Click on Ok
  5. Map the time dimension to created date
  6. Duplicate the "Job Start Date Time" Dimension
  7. Delete the original one as it doesn't allow us to use split function on it
  8. on duplicated dimension split the time stamp by (Space) using transformation
  9. Click on create model

Cause

  • The issue is currently investigated by Development.

Resolution

  • The issue is currently investigated by Development.

See Also

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0