MicroStrategy ONE

Bulk Export Setup dialog box: SQL Statements 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 SQL Statements tab of the Bulk Export Setup dialog box, you can specify SQL statements to be executed after the table is populated, but before the data is exported to a file. For instance, if you need to format the warehouse data in a particular way, you can run a SQL script to do so.

Related Topics