O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MDX Core Functions

Figure 10-4 shows the results after we changed the query to return a set of members on the ROWS axis. We did this by specifically listing the name of a dimension level in the MDX query (State-Province) and by using the MDX Members function. The Members function returns a list of all members in the State dimension level, plus an All Customers total. The All member is included in every dimension by default unless it has been specifically disabled, or hidden. The All member is also the default returned member when none is specified. The default member can be changed in the design of a dimension or by associating specific default members with particular security groups—that is, members of the WestRegion security group will see the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required