Contents of the x-Axis

This topic describes concepts for defining the <set> value, which defines the contents of an axis. The final <set> value for the x-axis of the example dataset shown in Cube and Dataset Example is provided in Set, Tuple, and Member Specification.

In the example dataset, the x-axis has two nested dimensions: SalesPerson and Geography. Two members are selected from the SalesPerson dimension: Smith and Jones. From the Geography dimension, four members are selected: Seattle, Boston, USA_South, Japan. This yields a total of eight coordinates on this axis (8 = 2*4).

You can represent each coordinate as a tuple with two members, one from the SalesPerson dimension and another from the Geography dimension, as follows:

(Smith, Seattle), (Smith, Boston), (Smith, USA_South), (Smith, Japan), (Jones, Seattle), (Jones, Boston), (Jones, USA_South), (Jones, Japan)

 

You can consider an axis as composed of a set of tuples. If there is only one dimension on an axis, then each tuple is just a member. If there are two dimensions, then two components compose each tuple, and each component is a member of one of the dimensions. In general, if there are n dimensions nested on an axis, then n components compose each tuple, and each component is a member of one of the dimensions.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.