| The query below returns all Fiscal months along with the top three members of the level below (Date) the supplied members July 2001 and July 2002.
|
| |
SELECT
{} ON COLUMNS,
DRILLDOWNMEMBERTOP([Date].[Fiscal].[Month].Members, {[Date].[Fiscal].[July 2001], [Date].[Fiscal].[July 2002]}, 3) ON ROWS
FROM
[Adventure Works]
|
| |
| |
| |
|
| |
|
| The query below returns all Country members from the Geography hierarchy in the Geography dimension along with the top three members in the level below (State-Province) the supplied member France.
|
| |
SELECT
{} ON COLUMNS,
DRILLDOWNMEMBERTOP([Geography].[Geography].[Country], {[Geography].[Geography].[Country].[France]}, 3) ON ROWS
FROM
[Adventure Works]
|
| |
| |
| |
|
| |
|