SAP Knowledge Base Article - Public

3070404 - SAC: Data Missing in Exported CSV File

Symptom

The exported file does not contain the data based on export schedule filter. 

Environment

SAP Analytic Cloud 1.0

Reproducing the Issue

  1. export account calculation and fact table data from model - data management - export
  2. select dimension member: X + Y in one of dimension filters
  3. export and check the exported file, data for X exists, but there is no data for member Y.
  4. source data under dimension member Y exists

Cause

the dimensions filters created a large data set result that exceeds the amount capable [a limit of 1 million rows] to be exported with calculations.

Resolution

add additional filters (e.g. monthly granularity instead of the whole year) 

Keywords

export, data, model, filter, sac, cloud, csv, file , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0