Database Reference
In-Depth Information
Figure 14-15.
The results of the example in Listing 14-20
Listing 14-20.
The Members and AllMembers Properties
With Member Measures.[test]
As "test data"
Select
{
[Measures].AllMembers
} On Columns -- includes calculated members
From [CubePubsSales];
GO
With Member Measures.[test]
As "test data"
Select
{
[Measures].Members
} On Columns -- Does NOT Include Calculated Members
From [CubePubsSales];
■
when using a function or property that returns multiple tuples, your MDX code does not require
braces, but most developers include them anyway. This MDX statement:
Select [Measures].Members On Columns
From [CubePubsSales];
is equivalent to this MDX statement with curly braces:
Select { ( [Measures].Members ) }
On Columns From [CubePubsSales];
.
Important