Home
Reports
Cognos Reports Installation and Configuration Guide
How to upgrade reports
You can upgrade your current version of Unica reports to bring it up-to-date with the latest features.
Upgrading Marketing Software integration components
To upgrade the Unica integration components, you must run the installers on the computer where Cognos® Content Manager is installed.

Reports
- 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 Marketing Software 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 Marketing Software and IBM Cognos
    After you install IBM Cognos®, you must integrate the Unica suite with IBM Cognos.
  - 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.
    - Upgrade prerequisites
      Before you upgrade your version of Unica reports, you must complete specific tasks.
    - Generating SQL to drop views, materialized views and run SQL in product databases
      You can use the Reports SQL Generator to generate drop table SQL commands and run them against the appropriate product system table database. Complete this task before you upgrade the reporting schemas.
    - Upgrading reporting schemas on Unica Platform
      You must run the Unica master installer with the reports packs installers to upgrade the reporting schemas and reports integration configuration properties.
    - Upgrading reporting templates on Unica Platform
      You must upgrade reporting templates in Unica Platform before you upgrade reports. If you are upgrading reports for Unica Plan, do not upgrade reporting templates because Unica Plan does not have reporting schemas.
    - Upgrading Marketing Software integration components
      To upgrade the Unica integration components, you must run the installers on the computer where Cognos® Content Manager is installed.
    - Updating lookup tables for Deliver and Unica Interact
      If you use reports for Unica Deliver and Unica Interact, you must update the lookup tables. Use your database client to run specific upgrade scripts against the system table database.
    - Upgrading views in the product databases
      To upgrade your version of reports, you must generate an updated SQL and upgrade the views in your product databases.
    - Upgrade Cognos Reports from version 12.1.0.0 to version 12.1.0.1
      To perform the upgrade of Cognos Reports from version 12.1.0.0 to version 12.1.0.1, complete the following steps.
    - Upgrade Cognos Reports from version 12.1.0.0 to version 12.1.0.3
  - 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.
  - 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.
- Unica Insights Reports Installation and Configuration Guide

Upgrading Unica integration components

To upgrade the Unica integration components, you must run the installers on the computer where Cognos® Content Manager is installed.

About this task

To upgrade Unica integration components, complete the following steps.

Procedure

On the IBM Cognos® BI system that runs the Cognos® Content Manager, download or copy the following Unica installers to a single directory:
- Unica master installer
- Unica Platform installer
- Unica application reports package installers
Run the Unica master installer.
It launches the sub-installers for Unica Platform and the report packages in order.
In the first Products window, ensure that both Unica Platform and the reports package options are selected.
In the Platform Database Connection window, provide the necessary information for connecting to the Unica Platform system tables.
In the Platform Installation Components window, select the Reports for IBM Cognos option and clear the other options.
When the Unica Platform installer prompts for the path to the JDBC driver, enter the fully qualified path for the JDBC driver that you copied to the Cognos® system during the initial install of reporting.

For more information, see Obtaining the JDBC driver for the Unica Platform system tables.
When the Unica Platform installer prompts for the location of the IBM Cognos® installation, enter or browse to the top level of the IBM Cognos® installation directory.

The default value that is provided in this field is a static value that is not based on the file structure of your IBM Cognos® system.
When the report package installer displays its installation options, select the IBM Cognos package for Unica [product] option and clear the option for the reporting schemas.
This installation option copies the reports archive to the Cognos® computer. You import this archive manually later.
When the installers are finished, copy the JDBC driver for the Unica Platform database to the IBM Cognos® webapps\p2pd\WEB-INF\AAA\lib directory.

Make sure that you copy the driver. Do not cut and paste the driver.

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.