Welcome
Reporting Guides
Superset Reports
Superset Reports Installation and Configuration Guide
Install and configure Superset reports
For information related to installation of Superset, see Cloud Native Unica Installation and Configuration Guide.

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.
      - Install Superset reporting components
      - Database Compatibility for Superset Reports
        The database compatibility of Superset Reports for the various products of Unica ae as follows:
      - Installation
        Installation of Apache Superset is covered in 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

Install and configure Superset reports

For information related to installation of Superset, see Cloud Native Unica Installation and Configuration Guide.

Note:

Before creating a Superset dashboard, confirm if you have completed the Superset configuration.
Before enabling Superset reports, ensure that you have disabled Unica Insights Reports.

To enable Superset reports within Unica, you must configure the following properties in the Settings > Configuration page and expand Reports and Integrations, and select Superset (Affinium|Reports|Integrations|Superset).

Enabled: Set to True to enable the Unica and Superset integrations. By default, this is set to False.
Superset URL: Superset instance URL.
Superset secret holder: Platform username against which the datasource created with name specified in Superset datasource property. The datasource contains the Superset Admin user login credentials, for example, asm_admin.
Superset Datasource: Datasource name created under the user specified in Superset secret holder property. For example, SUPERSET_DS.

Once the superset configuration in Unica is completed, you can create Superset dashboard through Platform Create dashboard page.

You will see the Embed Superset dashboard option while creating new dashboard only if following criteria is met:

The ReportsSystem role is assigned to the logged in user.
Under Superset node in Platform configuration, the Enabled flag is set to True.

After you create the embedded Superset dashboard, you can perform the all operations that can be performed in a standalone Superset environment.

Note:

User without ReportsSystem role, cannot create or edit the embedded Superset dashboard within Unica.
On click of Edit dashboard, all the list of charts available in Superset will be listed.
Deleting the Platform dashboard, will also delete its corresponding dashboard created in the Superset.
On the embedded Superset dashboards, edit chart and create chart are disabled using custom CSS.
If the charts added into embedded Superset dashboard uses userid in the SQL query then only user specific data is shown in the dashboard