SAP Knowledge Base Article - Public

2698303 - Model based on Salesforce connection does not retain hierarchy after updating model in SAP Analytics Cloud (SAC)

Symptom

  • Model based on Salesforce connection does not retain hierarchy after updating model in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2018.15.3

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a new model from Salesforce.
  3. Click Import button.
    => Note that Data Integration view doesn’t appear to perform data preparation. Instead, the model will be created directly.
  4. After the model is created, create a parent-child hierarchy in Modeler.
  5. Save and then go to Datasources tab.
  6. Click Update Model Now button.
  7. After the data refresh is completed, go to the dimension where the hierarchy is created in step 4
    => The hierarchy is still there.
  8. Leave and then re-open the model.
    => The hierarchy is missing.

Cause

This issue is bydesign. SAP Analytics Cloud does not support hierarchies for Salesforce dot com models currently. Thus, the defined hierarchies in the modeler will be wiped out after you refresh your model. The Refresh workflow for salesforce dot com connector cleans up the model and all its content. Because of the client-side caching the changes can only be seen after re-opening the model.

Resolution

  • We are planning to work on a new version of the connector to resolve these limitations for salesforce dot com models, in 2019.
  • Please raise an enhancement in our Customer Influence site.

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) , Bug Filed

Product

SAP Analytics Cloud 1.0