Breadcrumbs

Create a Multi Cube report

Overview

A Multi Cube report begins by creating one or more queries. Each query retrieves data from an Analytics cube and defines the information that will be available for reporting.

After creating the queries, you select the required columns and configure filters before combining the datasets through joins.

Before you create Multi Cube Analytics

Before creating a Multi Cube report, ensure that the following prerequisites are met:

  • You have identified the dimensions or fields that can be used to relate data between the selected cubes (for example, Year, Month, Cost Centre, or Consumer ID).

  • You know which fields you want to include in the final report and whether any calculated values will be required.

Understand the Multi Cube Analytics workspace

The workspace consists of two main areas.

Screenshot 2026-07-17 at 11.31.27 AM-20260717-071002.png

Report builder

The report builder is where you create the combined dataset. It contains the following sections:

Queries

Queries define which Analytics cubes participate in the report.

Screenshot 2026-07-17 at 11.31.36 AM-20260717-093232.png

Each query contains:

  • Analytics cube

  • Selected columns

  • Filters

You can add multiple queries to combine data from different cubes.

Joins

Joins define how records from different queries are related.

Screenshot 2026-07-17 at 11.33.25 AM-20260717-094024.png

You can configure:

  • From Query

  • Join Type

  • To Query

  • Matching fields

  • Matching columns

The selected join determines how records are combined before the visualization is generated.

Columns

Columns determine which fields become available to the visualization.

Only fields added to the Columns section can be used in reports and charts.

Screenshot 2026-07-17 at 11.39.56 AM copy 2-20260717-094802.png

Calculated Columns

Calculated columns allow you to derive new business metrics using formulas.

image-20260717-094946.png

Each calculated column includes:

  • Name

  • Formula

  • Aggregation type

  • Data type

Calculated columns are available only within the current Multi Cube report.

Example used for Multi Cube

This guide uses the following example throughout the remaining pages.

The objective is to combine data from the Expenses and Consumer Expenses Analytics cubes to analyze overall expenses alongside consumer-level expense information.

Query

Analytics cube

Q1

Expenses

Q2

Consumer Expenses

The completed report displays:

  • Consumer ID

  • Consumer

  • Year

  • Month

  • Overall Expenses

  • Consumer Expenses

  • Remaining Expenses

The same workflow can be applied to any supported Analytics cubes.

Create a Multi Cube report

Step 1 - Add your first query

  1. Navigate to Analytics > Multi Cube.

  2. In Fields pane, click +.

    Screenshot 2026-07-23 at 10.53.29 PM-20260723-172348.png

  3. Enter a query name.

    Screenshot 2026-07-17 at 11.31.27 AM-20260717-071002.png

  4. Select Add New Query (Q1).

  5. Select the Expenses Analytics cube.

  6. Select the required columns. For example scenario, add

    1. Year

    2. Month

    3. Spend

      image-20260723-183131.png

  7. Add filters if required and click SAVE.

Step 2 - Add additional queries

Repeat the same process for each Analytics cube required by the report. Each query retrieves data independently.

For this example:

  1. Select Add New Query (Q2).

  2. Select the Consumer Expenses Analytics cube.

  3. Select the required columns. For example scenario, add

    1. Consumer ID

    2. Consumer

    3. Year

    4. Month

    5. Spend

      image-20260723-184213.png

  4. Add filters if required and click SAVE.

Next steps

Once the queries have been created and verified, configure the relationships between them.

Continue to Build joins between queries

Related content