Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 247

SELECT
{
[Measures].[Sales Amount]
}
ON COLUMNS,
NON EMPTY {[Dim Reseller].[Business Type].members *
[Dim Geography].[English Country Region
Name].members}
DIMENSION PROPERTIES MEMBER_NAME ON ROWS
FROM [Adventure Works DW]
CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR,
BACK_COLOR
So far you have learned about Cube dimensions, how to add them to a cube,
define relationships and then query data along with the dimensions. Cube di-
mensions and their attributes and hierarchies contain several properties.
Some properties such as AttributeHierarchyEnabled, AttributeHierarchyVis-
ible, and the AttributeHiearchyOptimizedState reflect the state of the cube di-
mension hierarchies or attributes in the shared dimension by default. You can
override these properties so that appropriate settings are applied for the cube
dimensions within the cube. The properties AggregationUsage for attributes
and AllMember AggregationUsage for cube dimensions control the behavior
of aggregations designed on the cube. You learn more about these properties
in Chapters 9 and 13 .