Listing 1: MDX for Parameter-Level Dataset

WITH
MEMBER [Measures].[ParameterCaption]
   AS '[Customer].[Customer Geography]
   .CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue]
   AS '[Customer].[Customer Geography]
   .CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel]
   AS '[Customer].[Customer Geography]
   .CURRENTMEMBER.LEVEL.ORDINAL'
SELECT
{
[Measures].[ParameterCaption]
, [Measures].[ParameterValue]
, [Measures],[ParameterLevel]
} ON COLUMNS ,
{
STRTOMEMBER (@CustomerCustomerGeography)
} ON ROWS
FROM [AdventureWorks]