[>]

The [>] operator allows a temporary parent to be created from a sequential range of elements within a flat hierarchy.

This is commonly used with date dimensions or ordered lists.

Example Flat Hierarchy

Hierarchy name: Date List

2026-01-01
2026-01-02
2026-01-03
2026-01-05
2026-01-06
2026-01-07
2026-01-08
2026-01-09
...

The following expression:

Date List»2026-01-01[>]Date List»2026-01-04

creates a temporary parent containing the below elements:

• 2026-01-01
• 2026-01-02
• 2026-01-03
• 2026-01-04

Common Use Cases

• Date range reporting
• Rolling periods
• Custom time aggregations
• Dynamic subsets of flat hierarchies

Notes

• [>] works only on ordered flat hierarchies.
• The range is inclusive of both start and end elements.