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

Generating the SQL Script File

Now that you understand more about how to specify aggregates, you can write the aggregate logical SQL or generate a SQL script file using the Aggregate Persistence Wizard.

NOTE:  It is strongly recommended that you use the Aggregate Persistence Wizard because it automatically enforces many of the constraints outlined in the previous section. If you choose to write the SQL script manually, use the syntax as described in Guidelines for Writing the Create Aggregates Specification.