SAP Knowledge Base Article - Public

3495540 - Unable to export the calculated measures when exporting model as file in SAP Analytics Cloud (SAC)

Symptom

Cannot see the calculated measures when exporting model as file in SAC

Environment

SAP ANALYTICS CLOUD 2024.8.16

Reproducing the Issue

  1. Login to SAC
  2. Open the model
  3. Switch to Data Management tab
  4. Select the export and chose 'Export model as file' > 'Create New Schedule'
  5. 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.
  6. Set the maximum number of rows per file.
  7. In the 'Select Data' section, select the dimensions and measures to export.
  8. 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

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

Product

SAP Analytics Cloud 1.0