Multi Cube

Overview

Multi Cube Analytics enables you to create reports and visualizations using data from multiple Analytics cubes within a single report. Instead of being limited to a single cube, you can combine data from different business domains by creating queries, defining relationships between them, and building a unified dataset for analysis.

Unlike standard Analytics reports, which use a single cube, Multi Cube Analytics lets you:

• Query multiple Analytics cubes in one report.

• Define relationships between datasets using joins.

• Create calculated columns from combined data.

• Build visualizations using the unified dataset.

Benefits of Multi Cube Analytics

Multi Cube Analytics helps you:

• Combine data from multiple Analytics cubes into a single report.

• Build cross-domain reports without creating separate datasets.

• Create relationships between different business entities using joins.

• Create custom business metrics using calculated columns.

Before using Multi Cube Analytics

Before creating a Multi Cube report:

• Verify that the required data is available in the cubes.

• Identify the common field relationship between the datasets you want to combine.

How Multi Cube Analytics works

Creating a Multi Cube report follows a simple workflow.

1. Create one or more queries to retrieve data from Analytics cubes.

2. Configure joins to define how the datasets are related.

3. Create calculated columns to derive additional business metrics, if required.

4. Select the fields that will appear in the report.

5. Build a visualization to present the combined data.

6. Save the report for future use.

Next steps

To begin creating your report, continue to Create a Multi Cube report.

Related content

• Getting Started with Analytics

• Build joins between queries

• Create calculated columns

• Build report visualizations