Guide to Building Multi-Dimensional Ranges

In Cube, a multi-dimensional range is configured with more than one top-level dimension (TLD) in rows or columns.

Here are a few examples:

• 1x2 Range
• 2x1 Range
• 2x2 Range

1x2 Range

1 Column TLD x 2 Row TLDs

Example: T&E Expense, by Dept

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

2x1 Range

2 Column TLDs x 1 Row TLD

Example: Revenue by Entity 

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

2x2 Range

2 Column TLDs x 2 Row TLDs

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

1 Column TLD x 1 Row TLD