Loading templates for Reports SQL Generator

The reports packages for IBM® 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.

1.	Complete the following steps to run the script that loads the templates:

2.	Navigate to the schema directory under your report pack installation and locate the templates_sql_load.sql script.

3.	Run the templates_sql_load.sql script in the Marketing Platform database.