SAP Knowledge Base Article - Public

2605572 - How do I import both ID (identifier) and description master data into a dimension (into a blank or existing model) in SAP Analytics Cloud (SAC)?

Symptom

How do I import both ID (identifier) and description master data into a dimension (into a blank or existing model) in SAP Analytics Cloud (SAC)?

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Connect to SAP Analytics Cloud.
  2. Create a blank model via "Create > Model" and "Start with a blank model".
  3. Add a New or Existing Account dimension.
  4. Add a New or Existing Generic dimension called "Test".
  5. Import data into the model from a sheet with no column headers.
  6. Notice that the column for the description of "Test" does not get mapped to Dimension "Test".
  7. Notice that there is no way to map the column for the description of "Test" to Dimension "Test".

Resolution

Add column headers to your data file before importing the model that match the dimension name.

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, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, blank, model, dimension, description, import, load, file, map , 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) , How To

Product

SAP Analytics Cloud 1.0