2587147 - How to refresh existing models without modifying its hierarchies in SAP Analytics Cloud

SAP Knowledge Base Articles - public

2587147 - How to refresh existing models without modifying its hierarchies in SAP Analytics Cloud


You created a model importing from a SQL Database, BW or similar. During Data Integration (wrangling) you changed some names, created a hierarchy and implement other changes.

After the model is created, you schedule this datasource with the option Clean and replace and you observe that the hierarchies disappear and the descriptions are changed back to the original names in BW or your data source connection.


  • SAP Analytics Cloud


During the creation of a model, using a query is only a helper to create a model rather than creating it manually. However, once created, the data can be imported from multiple data sources. These data imports will record the transformations and respect names and hierarchies of the model.


This connection should only be used during model creation. You need to create a new connection importing data only and map these fields to your existing mode. These are the steps to follow:

  1. Navigate to the model that you want to import new data to.
  2. Open the model and select the first tab: Datasources.
  3. Select the option Import Data from ->]


You can import data from a different data source. In this example, I will be using exactly the same SAP NetWeaver BW BEx query used during creation of the model.


In this example, I can reuse the existing query I used during model creation.

When you finish importing the data into your model, you will see the new entry for Data Import that can be refreshed and scheduled without affecting the existing descriptions or hierarchies


Optional - Remove the query for Model Creation

If you want to avoid mistakes in the future scheduling the incorrect query, you can remove the query using during the creation of the model.


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.


description, label, key, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, import, changing, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , How To


SAP Analytics Cloud 1.0