Home
Reports
Unica Insights Reports Installation and Configuration Guide
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 from version 12.1.0.3 onwards.
Localize new Unica custom reports

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
  - 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
    Collaborate reports are supported from version 12.1.0.3 onwards.
  - 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.
  - 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 from version 12.1.0.3 onwards.
    - Localize new Unica custom reports
  - 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

Localize new Unica custom reports

You can localize your custom reports from version 12.1.0.3 onwards. Birt uses Resouces.properties files to translate strings. These files are copied to Unica_Home/Platform/Insights/Reports/ Resources folder.

Resource properties files possess a key for each string. In your custom reports, you must map keys for the report's strings in the report design. You can use Unica properties files for the strings, which are already translated. However, if you have new strings, you can get their translated strings from your language teams. Birt supports ASCII formatted translation.

For all new strings, you must also generate new keys which must follow a custom format. Ensure that you do not use Unica key format or numbers.

The following table provides the resource properties file names for Campaign and Deliver.


Product Name	Properties file
Campaign	CAResources_<locale>.properties
Deliver	DLResources_<locale>.properties

Unica provides languages support for Campaign and Deliver reports. It supports to following languages.


Language	Locale
English	en_us (default)
German	de_de
Spanish	es_es
French	fr_fr
Italian	it_it
Japanese	ja_jp
Korean	ko_kr
Portuguese	pt_br
Russian	ru_ru
Simplifies Chinese	zh_cn
Traditional Chinese	zh_tw

Navigate to Unica_Home/Platform/Insights/Reports/Resources folder to find all *.properties file names.

For more information and to learn how to apply keys or more, go to

https://wiki.eclipse.org/BIRT/FAQ/Internationalization

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.