Oracle^® Business Intelligence Server Administration Guide > Query Caching in the Oracle BI Server > Creating Aggregates for Oracle BI Server Queries >

Executing the SQL Script File to Create and Delete Aggregates

After generating the SQL script file and setting the logging levels, you need to execute the SQL script. You can run nQCmd.exe from the Command Line prompt or the Job Manager utility in the Administration Tool.

NOTE:  It is strongly recommended that you use Job Manager to run nQCmd.exe. For more information, refer to Oracle Business Intelligence Scheduler Guide. If you choose to run nQCmd.exe, a version can be found in the following Oracle BI installation folder: [installdrivepath]:\OracleBI\server\Bin.

After executing the SQL script, aggregates are created and persisted in the Oracle BI Server metadata as well as in the backend databases.