Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 898

◦ The MDX query generated by the query builder (which you
can happily ignore if so inclined) is
SELECT NON EMPTY { [Measures].[Fact
Internet Sales - Sales Amount] } ON COLUMNS,
NON EMPTY { ([Dim Geography].[State
Province
Name].[State Province Name].ALLMEMBERS
* [Dim
Customer].[Gender].[Gender].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM
( SELECT ( { [Dim Geography].[Sales
Territory Country].&[United States] } )
ON COLUMNS
FROM [Adventure Works DW])
WHERE ( [Dim Geography].[Sales
Territory Country].&[United States] )
CELL PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR,
FORMATTED_VALUE, FORMAT_STRING,
FONT_NAME, FONT_SIZE, FONT_FLAGS
◦ The query generated by the MDX query builder within Re-
port Designer is an MDX subselect query, which you learned
about in Chapter 7 . The above query contains two MDX se-
lect queries. The inner SELECT query restricts the cube
space based on the member [Dim Geography].[Sales Territ-
ory Country].[Sales Territory Country].&[United States], and
the outer SELECT query retrieves the data within the cube
space provided by the inner SELECT query.
◦ One important thing you should be aware of in the MDX
query builder is that if you switch from the design view to the
MDX view and make changes, at that point you are at risk of
losing the original configuration built in the design view if
you then return to the design view. Therefore, we do not re-
commend that particular action — if you want to return to
the design view. In the design view as you drag and drop