Hello,

From the DDL document located on Microsoft's web site:
http://www.microsoft.com/sql/evaluation/bi/ansvcddl.asp

My question involves the example of taking a slice from a cube to
create a local cube file as in the example below.

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]
)

My question is:

Given that there are levels in the Customer dimension (State Province,
City).

If we change this query so that we only include the state province
USA. Is the MDX syntax the following:

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],
MEMBER [Customers].[All Customers].[USA]
),
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 is the syntax written so the lower level pieces are included when
upper level members are specified. For instance, I want to see the
Cities, and Names for everything related to the upper level State
Province USA.

I have tried something similar with a different cube which has three
levels and the data for the lower levels do not appear. I wind up
with a really tiny cube file. Does anyone have insight with respect
to slicing cubes using this approach or could recommend a different
approach?

How can I include the lower level pieces in my create syntax?

Comments much appreciated.

TIA
--B