Loading templates for the Reports SQL Generator
The HCL® Marketing
Software 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 Marketing Platform database.