2490976 - Uable to import data to a Existing Model from Files including blank cells in SAP Analytics Cloud (SAC)

SAP Knowledge Base Article - Public

2490976 - Uable to import data to a Existing Model from Files including blank cells in SAP Analytics Cloud (SAC)

Symptom

Uable to import data to a Existing Model from Files including blank cells in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)

Environment

  • SAP Analytics Cloud 2017.11.0

Reproducing the Issue

  1. Log on to SAP Analytics Cloud.
  2. From main menu, select Browse > Models.
  3. Select Import Data From Files.
  4. Select one Target Model and one Source File including blank cells.
  5. Click Finish Mapping after clearing data quality issues.
    => Warning message appears to show that some rows are rejected.
    => Download the rejected rows in CSV format and then found that those rows have blank cells.

Cause

This behaviour is by design. In order to import data to an existing model, all the dimensions inside the model need to be mapped to non-empty IDs. In this case, a dimension ID is mapped to a blank value, and SAC cannot deal with blank IDs so the entire row is rejected.

Resolution

As a workaround, replace the blank cells with some distinct value ( ex. '#' ) and it will make the import successful.

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

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, import, file, blank, cells, cell, reject, rejected, row, rows, existing, model , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Bug Filed

Product

SAP Analytics Cloud 1.0