Symptom
Cannot see the calculated measures when exporting model as file in SAC
Environment
SAP ANALYTICS CLOUD 2024.8.16
Reproducing the Issue
- Login to SAC
- Open the model
- Switch to Data Management tab
- Select the export and chose 'Export model as file' > 'Create New Schedule'
- Choose whether you want to export data to a file on your local system, or to a file server, and then select a folder location to save the exported model to.
- Set the maximum number of rows per file.
- In the 'Select Data' section, select the dimensions and measures to export.
- Choose 'Fact Data Only' export option
Notice that the calculated measures are not exported.
Cause
This behavior is by design. For 'Fact Data Only' export, calculated measures can’t be exported.
Resolution
If you’re exporting a new model type with multiple measures, as opposed to a classic account model, make sure that you export all measures in a single export job.
In the Export Details-> Export Options -> Choose 'Data to be exported' as 'All Calculations and Fact Data' or 'Calculated Accounts and Measures"
See Also
- 2540886 How to export data from models in SAP Analytics Cloud?
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
export, measures, calculated measures, dimensions, file, export as file, data management, model, modeler, SAC, new model, classic model, export job, planning model, analytic model , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem