Home
Reports
Unica Insights Reports Installation and Configuration Guide
Reporting schemas
You must create reporting views to implement reporting for Unica Campaign, Unica Interact, and Unica Deliver. Reports can extract reportable data in the reporting views. The report packages for Unica Campaign, Unica Interact, and Unica Deliver include reporting schemas that the Reporting SQL Generator uses to produce SQL scripts that create reporting views.
Reporting deployment options
You can choose a deployment option when you run the Report SQL Generator tool.

Reports
- Unica Insights Reports Installation and Configuration Guide
  - Overview
  - Plan your Unica Insights reports installation
  - Install and configure Unica Insights reports
  - Upgrade Unica Insights reports
  - Configuring a user with the Reports System role
  - Creating JDBC data sources
  - Loading templates for the Reports SQL Generator
    The HCL Unica Insights reports use reporting schemas containing SQL scripts. These SQL scripts load template SQL select statements into the uar_common_sql table. The Reports SQL Generator uses the templates when it generates SQL scripts to create reporting views and tables.
  - SQL scripts by data source
  - Creating and populating reporting tables for Unica Campaign and Unica Deliver
  - Copy the Campaign and Deliver reports folder in Unica Insights directory
    Campaign installer places report design folders or files under Campaign installation directory.
  - Creating views or materialized views for Unica Campaign and Unica Deliver only:
  - Copy the Plan report folder in Unica Insights directory
  - Copy the Collaborate report folder in Unica Insights directory
  - Creating views or materialized views for Unica Interact only
  - Copy the Interact reports folder in Unica Insights directory
  - Creating and populating reporting tables
  - Setting up data synchronization
  - For Unica Deliver only: Stored procedures for delta processing
    Unica Deliver reports require staging tables that are associated with the Unica Deliver system tables. The system tables are part of the Unica Campaign schema. You must periodically run stored procedures to process message response data for use in Unica Deliver reports.
  - Update data source in Unica Insights report design files using Unica Insights utility
  - For Unica Deliver only: How to schedule and run stored procedures
    Unica Deliver reports use the data that is contained in staging tables, which are populated by stored procedures. The stored procedures perform a delta refresh operation. Run the stored procedures at least once per day. If you run the procedures more frequently, the delta refresh method prevents multiple concurrent runs.
  - How to configure Unica Insights to use HCL Unica authentication
  - Reporting schemas
    You must create reporting views to implement reporting for Unica Campaign, Unica Interact, and Unica Deliver. Reports can extract reportable data in the reporting views. The report packages for Unica Campaign, Unica Interact, and Unica Deliver include reporting schemas that the Reporting SQL Generator uses to produce SQL scripts that create reporting views.
    - The Report SQL Generator
      The Report SQL Generator uses the reporting schemas to determine the analytic logic that is necessary to extract data from the database for the Unica application. The Report SQL Generator then generates the SQL script that creates views or reporting tables that implement the logic and that enable business intelligence tools to extract reportable data.
    - Reporting deployment options
      You can choose a deployment option when you run the Report SQL Generator tool.
  - Campaign reports and reporting schemas
  - Interact reports and reporting schemas
    The Interact Report Package reports are supported by HCL reporting schemas. You can customize the schemas to specify time periods, configure audience levels, and create extra performance reporting schemas.
  - Format of the Unica Insights Reports
  - Integrate new custom reports in Unica
    Unica Insights enables you to integrate newly created custom reports with Unica for Campaign, Deliver, Plan, and Interact products.
  - Unica Insights Reports Customization
    You can create new reports, and modify and customize existing Unica Insights reports.
  - Customization of existing Unica Insights Reports for Campaign
  - Customization of existing Unica Insights Reports for Interact
  - Known issues
    The following is the list of Known Issues in Unica Insights Reports
- Cognos Reports Installation and Configuration Guide

Reporting deployment options

You can choose a deployment option when you run the Report SQL Generator tool.

When you run the Report SQL Generator tool, you specify whether you want the script to create views, materialized views. The deployment option you use depends on the amount of data that is contained in your system. See the Install and configure Unica Insights reports and Loading templates for the Reports SQL Generator sections to get the details on the supported databases for different products.

For smaller implementations, reporting views that directly query the production data might perform sufficiently for your needs. If they do not, try materialized views.
For medium-sized implementations, use either materialized views on the production system database or set up reporting tables in a separate database.
For large implementations, configure a separate reporting database.

Materialized views and Microsoft™ SQL Server

The reports application does not support materialized views for Microsoft™ SQL Server.

In SQL Server, materialized views are called "indexed views." However, the definition that creates an index in a view on SQL Server cannot use certain aggregations, functions, and options that the reporting views include. Therefore, if you are using a SQL server database, use views or reporting tables.

Note: For Unica Deliver, you must use views.

Unica Deliver and Oracle

If your installation includes Unica Deliver and your database is Oracle, you must use materialized views or reporting tables.

Unica Deliver and DB2®

If your installation includes Unica Deliver and your database is DB2®, you must use materialized views or reporting tables.

Data synchronization

When you deploy with materialized views or reporting tables, determine how frequently you want to synchronize the data with the production system data. Then, use your database administration tools to schedule data synchronization processes to refresh the reporting data regularly.

For Unica Deliver, the materialized views are automatically refreshed when you run the Unica Deliver delta refresh stored procedures. For more information, see For Unica Deliver only: How to schedule and run stored procedures.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.