Loading templates for the Reports SQL Generator

The Unica reports packages that use reporting schemas contain SQL scripts that load template SQL select statements into the uar_common_sql table. The Reports SQL Generator uses the templates when it generates SQL scripts to create reporting views and tables.

About this task

To run the script that loads the templates, complete the following steps.


  1. Browse to the schema directory under your report pack installation and locate the templates_sql_load.sql script.
  2. Run the templates_sql_load.sql script in the Unica Platform database.