SAP Knowledge Base Article - Public

2875065 - Error: "-999 Text: The result is limited to 500 rows (1003 in total). Limit your result for displaying further data or edit the drill limitation" occurs when exporting story table to CSV file

Symptom

  •  Error: "-999 Text: The result is limited to 500 rows (1003 in total). Limit your result for displaying further data or edit the drill limitation" occurs when exporting story table to CSV file
  • Total rows 1003 in error message less than imported data in model even though there is no filter in the table

Environment

  • SAP Analytics Cloud 2019.21.8

Reproducing the Issue

  1. Logon SAC.
  2. Create a story table by connecting Oralce data source.
  3. Select all dimensions in Rows and Account in Columns.
  4. Remove all filters.
  5. Export table to CSV, error occurs.
  6. Find total rows 1003 in error message less than imported data in model even though there is no filter in the table.

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.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

The result is limited to 500 rows, limitation, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0