SAP Knowledge Base Article - Public

3197488 - Exporting data from a model to Excel fails to download the expected information in SAP Analytics Cloud (SAC)

Symptom

When trying to download data from a model fact table using filters, the system is throwing a message with less data than expected.

Environment

  • SAP Analytics Cloud (Enterprise) 2022.2.12

Reproducing the Issue

1) Log into SAC and open the impacted model.
2) Go to Data Management
3) Go to Export Jobs section and select 'Export Model As File'> Create new schedule
4) Make the below option for the export:
- In the Export details tab:
Export Model to : File Repository
Data to be exported: Fact Data Only
Select the 2 options: Add separator information for use in Excel
Export fiscal date
- In the Select Data tab enter data for this information as filter:
Public - Category Filter.
Public- Time Filter.
Public- Organisation Filter
Public- Flow Filter.
Public- Audittrail Filter.
5) Click Export
-> a message appears shown that only way less lines are exported.
If we Export the data without any filters, it will show correct lines exported to csv file.
And if we make the same job filter for the data in the excel file, it will show the number of lines which is the correct lines number.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

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, 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 , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0