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

The following code shows the statements sent by OWC. First OWC drops
visual totals followed by creating two sets for the members of the hierarchies
selected on rows and columns of the OWC. OWC then queries the members
from the created sets and finally drops the earlier set Pivot13Axis1Set0 since
OWC has created new sets for members on rows and columns of the OWC.
Drop visual totals for [Adventure Works DW]
CREATE SESSION
SET [Adventure Works DW].[{}Pivot14Axis0Set0]
AS
'
{
{ [Dim Customer].[Gender].[All] },
AddCalculatedMembers ([Dim
Customer].[Gender].[Gender].MEMBERS)
}
'
SET [Adventure Works DW].[{}Pivot14Axis1Set0]
AS
'
{
{ [Dim Promotion].[English Promotion
Type].[All] },
AddCalculatedMembers ([Dim
Promotion].[English Promotion
Type].[English Promotion Type].MEMBERS)
}
'
SELECT
NON EMPTY [{}Pivot14Axis0Set0]
DIMENSION PROPERTIES MEMBER_NAME,
PARENT_UNIQUE_NAME ON COLUMNS,
NON EMPTY [{}Pivot14Axis1Set0]
DIMENSION PROPERTIES MEMBER_NAME,
PARENT_UNIQUE_NAME ON ROWS
FROM [Adventure Works DW]
CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR,
BACK_COLOR