SAP Knowledge Base Article - Public

2681397 - Invalid member values / rejected message when trying to import BPC data into an SAP Analytics Cloud (SAC) model created from a BPC datasource

Symptom

When you try to Import Data From SAP BPC into an SAP Analytics Cloud (SAC) model created from a BPC datasource, if there are new dimension members created in the source BPC model, those new dimension members are rejected and the new BPC dimension members are not added to the SAP Analytics Cloud (SAC) model / dimension.

This message appears in the SAC rejected data csv file:

[{"message":"Invalid member values.","type":0,"contents":[{"sourceColumnList":["<DimensionName"],"members":[["DimensionMember"]],"memberCount":{"0":1}}]}]

Data successfully imported. - 1 lines have been rejected - Invalid member values

Environment

  • SAP Analytics Cloud 2018.13

Resolution

This issue is resolved in 2018.14.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Rejected Lines, when exporting the data from BPC Model to SAC Planning model Very specific data set that is getting rejected, those rejected  aren't available in SAC dimension which ideally should get updated during the data export from BPC Model when refreshed reject list can be reproduced , KBA , sac , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0