If required a member is automatically converted to a set. The resulting set contains the member as single item.
Query
[Geography].[Geo].[Switzerland]
Result
{
[Geography].[Geo].[Country].[Switzerland]
}
Assertion : Cell Equals
{[Geography].[Geo].[Switzerland]}
If required a tuple is automatically converted to a set. The resulting set contains the tuple as single item.
Query
([Geography].[Geo].[Switzerland])
Result
{
[Geography].[Geo].[Country].[Switzerland]
}
Assertion : Cell Equals
{([Geography].[Geo].[Switzerland])}
If required a level is automatically converted to a set. The resulting set contains all level's members.
Query
[Geography].[Geo].[Country]
Result
{
[Geography].[Geo].[Country].[Canada],
[Geography].[Geo].[Country].[Mexico],
[Geography].[Geo].[Country].[United States],
[Geography].[Geo].[Country].[Venezuela],
[Geography].[Geo].[Country].[France],
[Geography].[Geo].[Country].[Spain],
[Geography].[Geo].[Country].[Switzerland]
}
Assertion : Cell Equals
[Geography].[Geo].[Country].members
If required a hierarchy is automatically converted to a set. The resulting set contains
the default member of the hierarchy as single item.
Query
Result
{
[Geography].[Geo].[All Regions]
}
Assertion : Cell Equals
[Geography].[Geo].defaultMember
If required an hierarchy is converted to a member; its default member is returned.
Query
[Geography].[Geo].children
Result
{
[Geography].[Geo].[Continent].[America],
[Geography].[Geo].[Continent].[Europe]
}
Assertion : Cell Equals
[Geography].[Geo].defaultMember.children
If required a null entity is automatically converted to a set. The resulting is an empty set.
Query
Result
Dimension with multiple hierarchies cannot be converted to a set.
Query
Result