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.
Procedure
-
Browse to the schema directory under your report pack installation and locate the
templates_sql_load.sql
script. -
Run the
templates_sql_load.sql
script in the Unica Platform database.