HCL TECHNOLOGIES ABOUT US PRODUCTS & SOLUTIONS RESOURCES CONTACT US

Home
HCL Marketing Software Reports Installation and Configuration Guide
An installation of the IBM® EMM reports is complete when you install IBM Cognos® BI and configure it for IBM EMM applications. The IBM EMM Reports Installation and Configuration Guide provides detailed information about configuring IBM Cognos BI, and integrating IBM Cognos BI and IBM EMM.
After you install or upgrade your reporting packages, you must configure your reporting installation.
You must create reporting view or tables to implement reporting for Campaign, Interact, and eMessage. Reports can extract reportable data in the reporting views or tables. The report packages for Campaign, Interact, and eMessage include reporting schemas that the Reporting SQL Generator uses to produce SQL scripts that create reporting views or tables
The Reporting SQL Generator uses the reporting schemas to determine the analytic logic that is necessary to extract data from the database for the HCL® EMM application. The Reporting SQL Generator then generates the SQL script that creates views or reporting tables that implement that logic and that enables business intelligence tools to extract reportable data.

Reporting SQL Generator

The Reporting SQL Generator uses the reporting schemas to determine the analytic logic that is necessary to extract data from the database for the HCL® EMM application. The Reporting SQL Generator then generates the SQL script that creates views or reporting tables that implement that logic and that enables business intelligence tools to extract reportable data.

During installation and configuration, the system implementers configured data source properties that identify the HCL EMM application databases. The Reporting SQL Generator connects to the application databases to complete the following tasks:

Validate scripts that create views or materialized views
Determine the correct data types to use in scripts that create reporting tables

If the JNDI data source names are incorrect or missing, the Reporting SQL Generator cannot validate scripts that create reporting tables.