HCL TECHNOLOGIES ABOUT US PRODUCTS & SOLUTIONS RESOURCES CONTACT US

Home
HCL Marketing Software Reports Installation and Configuration Guide
IBM® EMM and Cognos® integration
After you install HCL® Cognos®, you must integrate the IBM EMM suite with HCL Cognos.
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.

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.

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.