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

DROP SET [Adventure Works
DW].[{7868741D-072F-458A-8A8D-
EA3FED4A3FA7}Pivot13Axis1Set0]
Finally, drag and drop the measure [Sales Amount - Fact Internet Sales] to
Detail Fields. OWC once again generates statements to drop existing sets
and create new sets for members on rows and columns. These sets are used
in the query to retrieve the measure along with the properties of the cells. The
cell properties returned by the instance of Analysis Services are used by
OWC to display values. From the query you can see the properties of format-
ted values, foreground color, and background colors are being retrieved by
OWC. OWC uses the formatted value to display the cell values. The state-
ments and query sent to Analysis Services by OWC are shown below.
Drop visual totals for [Adventure Works DW]
CREATE SESSION
SET [Adventure Works DW].[{}Pivot15Axis0Set0]
AS
'
{
{ [Dim Customer].[Gender].[All] },
AddCalculatedMembers ([Dim
Customer].[Gender].[Gender].MEMBERS)
}
'
SET [Adventure Works DW].[{}Pivot15Axis1Set0]
AS
'
{
{ [Dim Promotion].[English Promotion
Type].[All] },
AddCalculatedMembers ([Dim
Promotion].[English Promotion Type].[English Promotion
Type].MEMBERS)
}
'
SELECT