Home
Reports
Cognos Reports Installation and Configuration Guide
Integration roadmap for Unica and IBM Cognos®
After you install IBM Cognos®, you must integrate the Unica suite with IBM Cognos.
Creating Cognos® data sources for Unica application databases
The Cognos® applications need their own data sources that identify the source of the data for Unica application reports.

Reports
- Unica Insights Reports Installation and Configuration Guide
- Cognos Reports Installation and Configuration Guide
  - Installation overview
    An installation of the Unica reports is complete when you install IBM Cognos® BI or Unica Insights reports and configure it for Unica applications. This guide provides detailed information about configuring IBM Cognos BI, and integrating IBM Cognos BI with Unica.
  - Plan the Unica reports installation
    When you plan your Unica reports installation, you must ensure that you correctly set up your system and configure your environment.
  - Install reporting components
    To install Unica reporting for your products, you must install the reporting components.
  - Install and test IBM® Cognos® BI
    Your license agreement with must grant you an Cognos® BI license so you can download the Cognos BI installation files. IBM Cognos BI is a collection of applications, servers, and services that is organized in a multi-tiered architecture.
  - Integration roadmap for Unica and IBM Cognos®
    After you install IBM Cognos®, you must integrate the Unica suite with IBM Cognos.
    - Obtaining the JDBC driver for the Unica Platform system tables
      You must obtain the JDBC driver for the Unica Platform system tables so that Cognos® can obtain the user information from the Unica Platform system tables. Cognos requires the user information for Unica authentication.
    - Installing the reporting models and integration component on the Cognos® system
      You must install the reporting models and integration components on the Cognos® system. If your installation of Cognos is in a distributed environment, you must install the reports package on the server where Cognos is installed.
    - Creating Cognos® data sources for Unica application databases
      The Cognos® applications need their own data sources that identify the source of the data for Unica application reports.
    - Optional: Setting up email notifications
      You can configure IBM Cognos® to send Unica reports as email attachments. This task is optional.
    - Configuring IBM Cognos® Application Firewall for Unica
      IBM Cognos® Application Firewall analyzes and validates requests before the requests are processed by IBM Cognos servers.
    - 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.
    - Loading templates for the Reports SQL Generator
      The Unica reports packages that use reporting schemas contain SQL scripts that 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.
    - Generating view creation scripts
      When you generate reports, you extract reportable data from the reporting views or tables. You can create reporting views by using the view creation scripts. Use the Reports SQL Generator to create view creation scripts.
    - Importing the reports folder in Cognos® Connection
      The Unica application reports are in the compressed (.zip) file that the report package installer copied to the Cognos® computer. You must import the compressed file into Cognos Connection.
    - Configuring and publishing the data model
      You must configure and publish the data model only if, when you set up the data source, you were logged in as a user who is not the owner of the application system tables.
    - Enabling internal links in the reports
      The Unica application reports have standard links. To enable the links to work properly, you must configure the IBM® Cognos® Application Firewall. You must also configure the redirect URL in the Cognos data model for the Unica application reports.
    - Verifying data source names and publishing
      The name that is specified as the data source for the reports in the model must match the name of the data source that you created in Cognos® Connection. Before you publish the model from Framework Manager to the Cognos content store, you must verify that the data source names match.
    - Configuring Cognos® reporting properties in Unica Platform
      There are several sets of properties for configuring reporting in Unica. Some properties define parameter values for the reporting components in Unica Platform. Some properties define URLs and other parameters for the Cognos® system. The properties that define parameter values are specified when the view creation scripts are generated. You must specify the properties that define URLs and other parameters for the Cognos system.
    - Setting report folder permissions
      If you configure the reports system to use the authenticated per user mode, make sure that the appropriate users can run the reports from the Unica applications. The easiest way to do this is to assign the default ReportsUser role to the appropriate user groups or users.
    - 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.
    - Stored procedures for the Unica Interact Event Pattern report
      The Unica Interact Event Pattern report uses the data that is contained in staging tables, which are populated by stored procedures. The stored procedures perform a delta refresh operation.
    - Changing the degree of parallel execution for the Interact Event Pattern report
      The degree of parallel execution value is configurable. Increase the degree of parallel execution for the Interact Event Pattern report aggregation process to reduce the elapse time. If the degree is set to a higher value, hardware resource requirements also increase proportionally
    - Log messages in the UARI_DELTA_REFRESH_LOG table for the Unica Interact Event Pattern report
      The UARI_DELTA_REFRESH_LOG table contains logging information for all procedures.
    - Testing your configuration before you enable authentication
      After the reports are installed and configured, you must test the configuration before you enable authentication. You can test the configuration by running a sample of reports.
    - How to configure IBM Cognos® to use Unica authentication
      The Unica Authentication Provider enables the Cognos® applications to use Unica authentication to communicate with the Unica suite as though it were another application in the suite.
    - Testing your configuration with authentication configured
      You must test your configuration of Cognos® BI after you configure authentication.
  - How to configure reporting
    After you install or upgrade your reporting packages, you must configure your reporting installation.
  - User authorization for Cognos folders and reports
    A Custom Java Authentication Provider (CJAP) provides authorization for users who access Cognos report folders and reports. You can implement this feature after you implement the Unica Authentication Provider, which provides single sign-on authentication between Unica applications and Cognos.
  - How to configure the Cognos® Reports for multiple partitions
    If you use Unica Campaign, Unica Deliver, or Unica Interact with more than one partition, you must configure the Cognos® reports packages for each partition. You can set up reporting on multiple partitions after you configure the partitions in Unica Campaign and Unica Deliver.
  - How to upgrade reports
    You can upgrade your current version of Unica reports to bring it up-to-date with the latest features.
  - Upgrading the 8.x or 9.x model and installing new reports
    Upgrading the 8.x or 9.x model and installing the new reports are the first steps that you must complete to upgrade your reports.
  - Report configuration properties
    The report configuration properties for Unica are available at Settings > Configuration > Reports.
  - Formats for the Cognos® reports
    The Cognos® reporting integration components include a global report style sheet, GlobalReportStyles.css.
  - Formats for the Unica Campaign, Unica Deliver, and Unica Interact Cognos reports
    Additional styling is required for Unica Campaign, Unica Deliver, and Unica Interact Cognos reports. The global report styles are modified to add classes to override the styling of existing classes to improve the look and feel of Unica Campaign, Unica Deliver, and Unica Interact reports.
  - Unica Campaign reports and reporting schemas
    You can customize the reporting schemas in the Unica Campaign Report Package by adding contact or response metrics, attributes, or response types.
  - Unica Deliver Reports and Reporting Schemas
    Several reports, such as Message Overview report, Detailed Link report, Deliver Reports Processing Overview, and SMS Message Summary Report are available in the Unica Deliver Reports Package.
  - Unica Interact Reports and Reporting Schemas
    The Unica Interact Report Package reports are supported by reporting schemas. You can customize the schemas to specify time periods, configure audience levels, and create extra performance reporting schemas.

Creating Cognos® data sources for Unica application databases

The Cognos® applications need their own data sources that identify the source of the data for Unica application reports.

About this task

The Cognos® data models that are provided in the Unica reports packages are configured to use the data source names that are given in the following table:

Table 1. Cognos® data sources
This two-columned table provides information about the Unica application in one column, and the Cognos® data source names in the second column.
Unica application	Cognos® data source names
Unica Campaign	CampaignDS
Unica Deliver	DeliverTrackDS
Unica Interact	For the design time database: InteractDTDS For the runtime database: InteractRTDS For the learning database: InteractLearningDS For the ETL database: InteractETLDS
Unica Plan	PlanDS
Unica Collaborate	For the Unica Collaborate database: CollaborateDS For the customer database: CustomerDS For the Unica Campaign database: CampaignDS

Use the following guidelines to create Cognos® data sources for the HCL application databases.

Procedure

Use the Administration section of Cognos® Connection.
Use the default data source names that are shown in the Cognos® data sources table to avoid having to alter the data model.
The database type that you select must match that of theHCL application database. Use the Cognos® documentation to determine how to fill database-specific fields.

Note: For Unica Campaign and Unica Deliver, the appropriate database is Unica Campaign.
Be sure that you identify the Unica application database and not the Cognos® content store.
When you configure the Signon section, select the Password and Create a Signon that the Everyone group can use options.
In the Signon section, specify the user credentials for the Unica application database user.
Consult the Cognos® data sources table and ensure that you create all the data sources that are required by the data model for the reports you are configuring.
For example, the reporting data for Unica Interact is in three databases, so you must create separate Cognos® data sources for each database.
If the Unica Campaign system has more than one partition, create separate data sources for each partition.
For example, if Unica Campaign and Unica Deliver are configured for multiple partitions, create a separate Unica Campaign and Unica Deliver data source for each partition.
Verify that you configured each data source correctly by using the Test Connection feature.

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.