Loading templates for Reports SQL Generator
The reports packages for HCL® EMM applications that have reporting schemas contain an SQL script that loads template SQL select statements into the uar_common_sql table. The Reports SQL Generator uses the templates while generating SQL scripts for creating the reporting views or tables.
Procedure
Complete the following steps to run the script that loads
the templates:
- 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.