If you are performing a dimension build, skip this section.
You can express member names as ranges within a dimension. For example, Sales and COGS form a range in the Measures dimension. Ranges of member names can handle a series of values.
A data source can contain ranges from multiple dimensions at a time. In the example below, Jan and Feb form a range in the Year dimension and Sales and COGS form a range in the Measures dimension.
Actual Texas Sales COGS Jan Feb Jan Feb "100-10" 98 89 26 19 "100-20" 87 78 23 32
Notice that Sales is defined for the first two columns and COGS for the last two columns.