Symptom
It is not possible to export the calculated measures from SAP Analytics Cloud (SAC) to other systems either by the PUSH export (legacy export from the Modeler -> Data Management -> Export jobs) or the PULL export (Data Export Service API).
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
Export data from SAC to other systems by Modeler -> Data Management -> Export jobs or the Data Export Service (DES) API.
Cause
This is the current design.
Resolution
Currently we cannot export calculated measures. However, there is a workaround:
- There is a model with the calculated measures. Now you can create a second model that contains all base measures as in the original model but also one base measure for each of the calculated measures.
Now when using a cross model copy, you can map each calculated measure to the corresponding base measure in the second model.
When the cross model copy is executed, the system calculates the calculated measures and persists them in the base measures of the second model.
Now you can export the data with the calculated results from the second model.
The advantage of this approach is that the system automatically does this calculation and persisting of the values once you map the calculated measures to the target base measures in the target model.
If you would like to have a new feature to support the calculated measure export, you can create an enhancement request as per KBA 2424376. The product owners will review and implement the high-voted requests in the future SAC versions.
See Also
- 2540886 - How to export data from models in SAP Analytics Cloud?
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, unable , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem