SAP Knowledge Base Article - Public

2788802 - New members rejected error occurred when refresh the data source of model in SAP Analytics Cloud (SAC)

Symptom

When importing data to a SAC model the data load rejects rows that contain a new member for a dimension in the data model, failure reason is New members rejected, although in the import option update dimension with new values is checked.

Environment

SAP Analytics Cloud 2019.8.6

Reproducing the Issue

  1. Open the model in customer system
  2. Switch to the Data Management tab
  3. In the Import Jobs panel, click the refresh button (Refresh source grouping now)
  4. Notice that there is a warning indicated some rows are rejected, download the CSV file and found that the failure reason is New members rejected. But in the import options, update dimension with new values is checked.

Cause

The reason the values are rejected is because the dimension in question is “public dimension” (as shown in by the globe icon in the modeler UI).

Public dimension does not belong to the model, but rather is referenced by it; a single public dimension can be used in multiple models. As such, public dimension update has its own life cycle.

Resolution

To add dimension members to such public dimension, you can do an import data to public dimension process directly. This should be done prior adding fact data to the model.

You may refer to the chapter “Import data into public dimensions” for more info.

See KBA: 2455585  for more details.

 

See Also

Your feedback is important to help us improve our knowledge base.

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 , KBA , 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) , Bug Filed

Product

SAP Analytics Cloud 1.0