SAP Knowledge Base Article - Public

2803806 - Data validate fails when adding a location dimension based on Area Name for Germany data in SAP Analytics Cloud (SAC)

Symptom

Data validate fails when adding a location dimension based on Area Name for Germany data in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2019.11

Reproducing the Issue

Prepare Germany State and City data like below:

Country Expected State Current State in SAC Expected City Current City in SAC
Germany Bavaria Bavaria Munich Munich
Germany Saxony Saxony Dresden Dresden
Germany North Rhine-Westphalia North-Rhine-Westphalia Cologne Cologne
Germany Baden-Wurttemberg Baden-Wurttemberg Stuttgart Stuttgart
Germany Rhineland-Palatinate Rhineland-Palatinate Trier Trier-Saarburg
Germany Saarland Saarland Saarbrucken Saarbrucken
Germany Hesse Hesse Frankfurt am Main Frankfourti
Germany Lower Saxony Lower-Saxony Hanover Hanover
Germany Bremen Bremen Bremen Bremen
Germany Hamburg Hamburg Hamburg Hamburg
Germany Schleswig-Holstein Schleswig-Holstein Kiel Kiel
Germany Mecklenburg-Western Pomerania Mecklenburg-Vorpommern Rostock Rostok
Germany Brandenburg Brandenburg Potsdam Potsdam
Germany Saxony-Anhalt Sachsen-Anhalt Magdeburg Magdeburg
Germany Thuringia Thuringia Erfurt Erfurt
Germany Berlin Berlin Berlin

Berlin

 

  1. Log on to SAP Analytics Cloud.
  2. Use the above data to create a Model.
  3. Add a location dimension Geo Enrich by -> Area Name
  4. Select Country as Country column, Region as "Expected State" column, Sub-Region as "Expected City" column.
  5. Notice there are validation errors happens.
  6. If select Country as "Country" column, Region as "Current State in SAC" column, Sub-Region as "Current City in SAC" column, the validation will be OK. However this contains incorrect State and City names.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

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