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:
1 Column TLD x 2 Row TLDs
2 Column TLDs x 1 Row TLD
2 Column TLDs x 2 Row TLDs
1x1 Range (NOT a multi-dim. range)
1 Column TLD x 1 Row TLD
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)