Database Reference
In-Depth Information
SELECT
[Measures].[Sales Amount] ON 0,
VISUALTOTALS(
{[Order Date].[Hierarchy].[All],
[Order Date].[Hierarchy].[Calendar
Year].&[2006],
[Order Date].[Hierarchy].[Calendar
Year].&[2007]
}) ON 1
FROM [Adventure Works DW2012];
In this case, instead of the
All
level for the entire cube what is actually returned is
the sum of the sales for 2006 and 2007.
Now that you have got a primer in MDX, it is time to look at some other tools that
can be used to query cubes. The interesting thing about these tools is that they auto
create MDX dynamically, so that you do not need to write it by hand.
Search WWH ::
Custom Search