License Guide
Requirements Guide
Fast Upgrade Guide
Reporting Guides
- Superset Reports
  - Overview
    HCL Unica supports Apache Superset (an Open source BI tool). This tool has competitive dashboarding capabilities.
  - Superset Reports Installation and Configuration Guide
    - Plan your Superset reports installation
    - Install and configure Superset reports
      For information related to installation of Superset, see Cloud Native Unica Installation and Configuration Guide.
    - Unica Campaign Configuration and Reporting Schema
    - Unica Centralized Offer Management Configuration and Reporting Schema
    - Unica Deliver Configuration and Reporting Schema
    - Unica Journey Configuration and Reporting Schema
    - Unica Interact Configuration and Reporting Schema
    - Unica Plan Configuration and Reporting Schema
    - Unica Real Time Personalization Configuration and Reporting Schema
    - Configuring a user with the Reports System role
    - Loading templates for the Reports SQL Generator
    - Creating and populating reporting tables for Unica Campaign and Unica Deliver
    - Creating views or materialized views for Unica Campaign and Unica Deliver only:
    - 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.
    - 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.
    - Fixed defects
      The following is the list of Fixed Defects in 25.1.0.1 of Superset Reports
    - Known limitations
      The following is the list of Known Limitations in 25.1.0 of Superset Reports
    - Known issues
      The following is the list of Known Issues in Superset Reports:
- Insights Reports
- Cognos Reports

Unica Journey Configuration and Reporting Schema

Datasource Configuration

Login to the Superset environment.
Navigate Settings > Database Connections.
Edit JourneyDS.
Provide password for the database user.
Test the connection.

Verifying the Setup

Navigate to Dashboards.
Filter Journey_Analytics or Journey_Dashboard.
Run each dashboard they should run without any error.

Journey Datasets


Report Name	Description
Audience Comparison Entry Sources	This dataset provides a comparison of Entry sources with respect to audiences.
Audience Comparison Across Channel	This dataset provides a comparison of Channels (touchpoints) with respect to audiences.
Journey Channel Performance	This dataset provides a comparison of Journeys with respect to various channels.
Milestone Funnel	This dataset shows a Journeys progress throughout defined milestones.
Accepted/Rejected Audiences Across Journeys	This dataset provides a detail about accepted and rejected audience data for Journeys.
Journey Overview	This dataset provides details about Active, Completed, Paused, Draft Journey Counts.

Customize your Reports

You can customize or create new Unica Journey reports using out of the box datasets. These datasets consist of database SQLs. We recommend that you do not modify existing datasets in case you want to create a new field in the same. Instead, you can make a copy of it to modify SQL of datasets.

For more information, see https://superset.apache.org/docs/intro documentation.