Hello,

Using the example from the Microsoft's Analysis Server DDL
documentation at:
http://search.microsoft.com/gomsuri....i/ansvcddl.asp

CREATE GLOBAL CUBE SalesCA STORAGE 'C:\SalesCA.cub' FROM [Sales]
(
MEASURE [Sales].[Unit Sales],
MEASURE [Sales].[Store Cost],
MEASURE [Sales].[Store Sales],
MEASURE [Sales].[Sales Count],
MEASURE [Sales].[Store Sales Net],
DIMENSION [Sales].[Customers]
(
LEVEL [State Province],
LEVEL [City],
MEMBER [Customers].[All Customers].[USA].[CA]
),
DIMENSION [Sales].[Education Level],
DIMENSION [Sales].[Gender],
DIMENSION [Sales].[Marital Status],
DIMENSION [Sales].[Product],
DIMENSION [Sales].[Promotion Media],
DIMENSION [Sales].[Promotions],
DIMENSION [Sales].[Store],
DIMENSION [Sales].[Store Size in SQFT],
DIMENSION [Sales].[Store Type],
DIMENSION [Sales].[Time],
DIMENSION [Sales].[Yearly Income]
)


How can you adjust the query to include members in the lower level
dimension name which correspond to the City CA?

Thanks
--B