Databases Reference
In-Depth Information
WITH MEMBER [Date].[Calendar].[%Change] AS
100* (([Date].[Calendar].[Calendar Quarter].[Q2 CY
2002] -
[Date].[Calendar].[Calendar Quarter].[Q1 CY
2002]) /
[Date].[Calendar].[Calendar Quarter].[Q2 CY 2002])
SELECT {[Date].[Calendar].[Calendar Quarter].[Q1 CY
2002],
[Date].[Calendar].[Calendar Quarter].[Q2 CY 2002],
[Date].[Calendar].[%Change]} ON COLUMNS,
Measures.[Internet Sales Amount] ON ROWS
FROM [Adventure Works]
The above query shows an example of a calculated member defined in the
Date dimension to return a quarter-over-quarter comparison of the sales
amount. In this example, quarter 1 and quarter 2 of the year 2002 are being
used. The result of this query is
Q1 CY 2002
Q2 CY 2002
%Change
Sales Amount $1,791,698.45 $2,014,012.13 11.038
Search WWH ::
Custom Search