SAP Knowledge Base Article - Public

2468715 - How to change the data source in a model in SAP Analytics Cloud (SAC)

Symptom

User has multiple connections and would like to switch the data source of one of their models to another connection, while retaining the existing model.

Example: You have multiple HANA systems: Production, Quality, etc. You created your model using a calculation view in DEV and you want to move it now to use the data in Production.

Environment

SAP Analytics Cloud

Resolution

You can change the Data Source of the model following these steps:

  1. In modeler, select the model you want to change
  2. Open the model
  3. Using the wrench tool on the top left of the modeler, select Change Data Source.
  4. Select the new connection and view you want to use
  5. You will be prompted to accept the stories currently using this model that can be affected: Your model has dependencies, and changing the datasource can affect all of them. Do you want to change the data source anyway?
  6. If some measures or dimensions changed in the Calculation View, you will see the following message: The highlighted rows contain entries that have been changed or added in SAP Analytics Cloud
Changing the Data Source

Change_Data_Source.png

Stories_Affected.png
Highlighted_rows.png

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, SAP BusinessObjects Cloud , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , How To

Product

SAP Analytics Cloud 1.0