Reporting schemas

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

For Campaign and Interact, you must customize the schema templates, so the data that you want to include in your reports is represented. You can run the Reporting SQL Generator after you customize the schema templates. You can run the SQL scripts that the SQL Generator generated and run the scripts on your application databases.

You cannot customize the eMessage reporting schemas. However, you must generate the SQL script that builds the reporting views or tables and then run the scripts on the eMessage databases.

The reporting schemas make it easier for you to use any third-party reporting tool to examine your HCL® application data. However, if you want to display reports in the IBM EMM user interface, your installation must be integrated with IBM Cognos® BI.