Home
Reports
Cognos Reports Installation and Configuration Guide
Report configuration properties
The report configuration properties for Unica are available at Settings > Configuration > Reports.
file:/D:/HCL_marketing/MktOps/Reports/UG_Status_and_type.dita
The Interact Performance schema yields contact and response history metrics at the channel, channel-offer, channel-segment, channel-interaction point, interactive cell, interactive cell-offer, interactive cell-interaction point, interactive offer, interactive offer-cell, and interactive offer-interaction point levels.

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.
  - 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.
    - Reports | Integrations | Cognos [version]
      The Unica suite integrates with Cognos to generate reports.
    - Reports | Schemas | [product] | [schema name] | SQL Configuration
      The SQL script creates views for the reporting schemas. The Reports | Schemas | [product] | [schema name] | SQL Configuration property provides information about the name of the views.
    - Reports | Schemas | Campaign
      The Reports | Schemas | Campaign property provides information about the data source that identifies the Unica Campaign database.
    - Reports | Schemas | Campaign | Offer Performance
      The Offer Performance Schema yields contact and response history metrics for all offers and for offers by campaign. By default, the schema is configured to generate a "summary" view across all time.
    - Reports | Schemas | Campaign | [schema name] | Columns | [Contact Metric]
      Use the Reports | Schemas | Campaign | [schema name] | Columns | [Contact Metric] property to add contact metrics to the Campaign Performance or Offer Performance reporting schemas.
    - Reports | Schemas | Campaign | [schema name] | Columns | [Response Metric]
      Use the Reports | Schemas | Campaign | [schema name] | Columns | [Response Metric] property to add the response metrics that you want to include in your reports to the Campaign Performance or Offer Performance reporting schemas.
    - Reports | Schemas | Campaign | Campaign Performance
      The Campaign Performance schema yields contact and response history metrics at the campaign, campaign-offer, and campaign-cell level.
    - Reports | Schemas | Campaign | Campaign Offer Response Breakout
      The Campaign Offer Response Breakout schema supports reporting on campaign-detailed responses, which are broken out by response type and by offer data. This schema template gives different response counts for each custom Response Type for campaigns and offers grouped by campaign.
    - Reports | Schemas | Campaign | Campaign Offer Response Breakout | Columns | [Response Type]
      Use the Reports | Schemas | Campaign | Campaign Offer Response Breakout | Columns | [Response Type] property to add any custom response types that you want to include in your reports to the reporting schema.
    - Reports | Schemas | Campaign | Campaign Offer Contact Status Breakout
      The Campaign Offer Contact Status Breakout schema supports reporting on campaign-detailed contacts, which are broken out by contact status type and by offer data. This schema template gives different contact counts for each custom Contact Status Type for campaigns and offers grouped by campaign.
    - Reports | Schemas | Campaign | Campaign Offer Contact Status Breakout | Columns | [Contact Status]
      Use the Reports | Schemas | Campaign | Campaign Offer Contact Status Breakout | Columns | [Contact Status] to add the contact status that you want to include in your reports to the reporting schemas.
    - Reports | Schemas | Campaign | Campaign Custom Attributes | Columns | [Campaign Custom Column]
      Use the Reports | Schemas | Campaign | Campaign Custom Attributes | Columns | [Campaign Custom Column] property to add any custom campaign attributes that you want to include in your reports to the reporting schema.
    - Reports | Schemas | Campaign | Campaign Custom Attributes | Columns | [Offer Custom Column]
      Use the Reports | Schemas | Campaign | Campaign Custom Attributes | Columns | [Offer Custom Column] property to add any custom offer attributes that you want to include in your reports to the reporting schema.
    - Reports | Schemas | Campaign | Campaign Custom Attributes | Columns | [Cell Custom Column]
      Use the Reports | Schemas | Campaign | Campaign Custom Attributes | Columns | [Cell Custom Column] property to add any custom cell attributes that you want to include in your reports to the reporting schema.
    - Reports | Schemas | Interact
      The Unica Interact reporting schemas reference three separate databases: the design time, runtime, and learning databases. Use the Reports | Schemas | Interact property to specify the JNDI names of the data sources for those databases.
    - file:/D:/HCL_marketing/MktOps/Reports/UG_Status_and_type.dita
      The Interact Performance schema yields contact and response history metrics at the channel, channel-offer, channel-segment, channel-interaction point, interactive cell, interactive cell-offer, interactive cell-interaction point, interactive offer, interactive offer-cell, and interactive offer-interaction point levels.
    - Reports | Schemas | Deliver
      The Reports | Schemas | Deliver property specifies the name of the data source that identifies the Unica Deliver tracking tables, which are in the Unica Campaign system tables.
    - Campaign | partitions | partition[n] | reports
      The Campaign | partitions | partition[n] | reports property defines the different types of folders for 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

Reports | Schemas | Interact | Interact Performance

The Interact Performance schema yields contact and response history metrics at the channel, channel-offer, channel-segment, channel-interaction point, interactive cell, interactive cell-offer, interactive cell-interaction point, interactive offer, interactive offer-cell, and interactive offer-interaction point levels.

Audience Key

Description

Specifies the name of the column that is the Audience Key for the audience level that is supported by this reporting schema.

Default value

CustomerID

Valid Values

A string value no longer than 255 characters.

If the key includes more than one column, use commas between the column names. For example, ColumnX,ColumnY.

Detailed Contact History Table

Description: Specifies the name of the Detailed Contact History table for the audience level that is supported by this reporting schema.
Default value: UA_DtlContactHist

Response History Table

Description: Specifies the name of the Response History table for the audience level that is supported by this reporting schema.
Default value: UA_ResponseHistory

Over Time Variations

Description: Specifies the calendar time periods that are used by the "over time" reports supported by this schema.
Default value: Hour, Day
Valid Values: Hour, Day, Week, Month, Quarter, Year

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.