This topic describes how to generate the CSV output for large reports.
If you choose only the CSV output format, without selecting any other output formats, the CSV output for large reports doesn't cause memory issues.
Requirements
To enable only CSV output, set the Enable CSV Output property in the Data Model Properties page.
Limitations
The data engine cannot generate a CSV output when:
The SQL query contains the CLOB/BLOB columns
When a query includes CLOB columns, the data processor cannot generate the CSV output because the LOB might be XML data or non-structured data. Converting the LOB columns to flattened a CSV format doesn't scale. This type of conversion requires complex code changes that are similar to embedding a formatting engine inside the data engine.
The SQL query contains the DFF/EFF columns
When a query includes a DFF (Descriptive Flexfield) or EFF (Extensible Flexfield) columns, the data processor cannot generate a CSV output. Each DFF or EFF column is treated as a nested sub-group in the query, which results in nested XML data. You cannot flatten a nested XML data directly to a CSV output.
The data model has both SQL and Non-SQL data sets
When a data model contains a mix of SQL and Non-SQL data sets (Non-Standard data sets such as web-service, http, and xml), the data processor cannot generate a CSV output.
The data model has a non-standard SQL query
When a data model has a non-standard query such as a procedure or a function that returns a reference, the data processor cannot directly generate a CSV output. The non-standard queries returning nested XML structure cannot be handled inside the data engine.
The scheduled report has multiple output formats
If you select multiple output formats for the scheduled report, the data processor doesn't generate the CSV output directly from the XML file.
The scheduled report uses bursting
The data engine doesn't directly generate the CSV format for report bursting. Splitting and delivering data requires raw XML data parsing.