MicroStrategy ONE
Bulk Export Setup dialog box: Advanced tab
The Bulk Export feature enables you to export a report to a delimited text file. Using this feature, you can retrieve result sets from large datasets without having to load the datasets in memory. For more information on bulk export reports, see the Reports chapter of the Advanced Reporting Help.
From the Advanced tab of the Bulk Export Setup dialog box, you can configure the following bulk export settings:
-
Maximum time for SQL execution to build table (sec): If this time limit is reached before the table is built, the export is cancelled with a timeout error.
-
Maximum time for exporting data to file (sec): If this time limit is reached before the file is completely written, the export is cancelled with a timeout error.
-
Number of rows retrieved in each step: The number of database rows that the bulk export retrieves at a time.
-
Table space: The database table space in which the temporary table for the bulk export is created.
-
Table prefix: The table prefix for the bulk export temporary table.