Databases Reference
In-Depth Information
The Tuples (Customer.Country.Australia) and (Customer.Country.Canada) are
resolved to the exact same dimension. A collection of these two Tuples is a
valid Set and is specified as
{(Customer.Country.Australia),
(Customer.Country.Canada)}
Example 2
The tuples (Customer.Country.Australia, [Product].[Product Line].[Mountain])
and (Product.Country .Canada, [Date].[Calendar].[2004].[H1 CY 2004].[Q1
CY 2004]) cannot be combined to form a set. Even though they are formed by
two dimensions, the dimensions used to resolve the tuple are different. Both
tuples have the Customer dimension but the second dimensions are different.
Example 3
Each of the following tuples has the three dimensions Date, Product, and
Customer.
1. ([Date].[Calendar].[2004].[H1 CY 2004].[Q1 CY
2004], [Product].[Product Line].[Mountain],
[Customer].[Country].[Australia]),
2. ([Product].[Product Line].[Mountain],
[Customer].[Country].[Australia],
([Date].[Calendar].[2002].[H1 CY 2002].[Q1 CY 2002])
3. ([Customer].[Country].[Australia],
Date].[Calendar].[2003].[H1 CY 2003].[Q1 CY 2003],
[Product].[Product Line].[Mountain] )
Search WWH ::
Custom Search