SAP Knowledge Base Article - Public

3775355 - Decimals missing when exporting "all calculations and fact data" from model in SAP Analytics Cloud (SAC)

Symptom

  • When using the export function and selecting "All calculations and fact data," exported measures do not include decimal points.
  • When selecting "Fact data only," exported measures include decimal points as expected.
  • Measures includes Calculated Measure, Conversion Measure and Measure.

Environment

  • SAP Analytics Cloud (Enterprise) 

Reproducing the Issue

  1. Open an imported model that contains both fact data and calculation results.
  2. Start an export job from the modeler and choose to export the model as a file.
  3. Select the option "All calculations and fact data" and perform the export.
  4. Observe that exported numeric values have no decimal digits.
  5. Repeat the export with the option "Fact data only" and observe that decimals are preserved.

Cause

  • In models containing both measures and accounts, Structure Priority was set to Account, so account-level formatting overrides measure-level formatting during export.
  • Relevant account members had their decimal places set too low (for example, 0), causing calculated values to be rounded and exported as integers when "All calculations and fact data" is selected.

Resolution

  1. In the model, open Model Settings and set Structure Priority to Measure so that measure formatting (decimal places) is applied during export.
  2. Navigate to Calculations and set Decimal Places on any Measure that you want to export.
  3. Re-run the export with "All calculations and fact data" and verify that decimal places are preserved.
  4. Alternatively, if Structure Priority must remain set to Account, edit the affected account members and set their Decimal Places property to the required precision (for example, 6), then export again.

Keywords

sac export, export model as file, all calculations and fact data, decimals missing, decimal places, rounding in export, csv export, structure priority, account formatting, measure formatting, calculated measures, formatting override, export jobs, fact data only, numeric precision , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions