This article illustrates what a multi-dimensional range is and provides a few examples of ones you can build in Cube.

What is a multi-dimensional range?

In Cube, a multi-dimensional range is one that's configured with more than 1 top-level dimension (TLD) in rows or columns. A few examples:

1x2 Range

1 Column TLD x 2 Row TLDs

2x1 Range

2 Column TLDs x 1 Row TLD

2x2 Range

2 Column TLDs x 2 Row TLDs

1x1 Range (NOT a multi-dim. range)

1 Column TLD x 1 Row TLD

Use Cases

There are several ways you can utilize multi-dimensional ranges. Here are a few examples if you aren't sure where to start. 

Actuals vs. Budget (2x1 Range)

2 Column TLDs (Time: Q1-20 & Scenario: Actuals, Budget) x 1 Row TLD (Account: Revenue)

T&E Expense, by Dept. (1x2 Range)

1 Column TLDs (Time: Q1-20) x 2 Row TLDs (Department: Sales, Marketing & Account: Travel and Entertainment)

Revenue, by Entity (2x1 Range)

2 Column TLDs (Entity: Sample Co LTD, Sample Co GmbH, All Entities & Time: Jan-20, Feb-20) x 1 Row TLD (Account: Revenue)