Below is the grouping example using Create Session Cube.

CREATE SESSION CUBE [SalesAssignmentsCA] FROM [SalesCA]
(
MEASURE [SalesCA].[Unit Sales],
DIMENSION [SalesCA].[Time],
DIMENSION [SalesCA].[Customers] HIDDEN AS [HiddenCustomers],
DIMENSION [Customers] NOT_RELATED_TO_FACTS FROM [HiddenCustomers]
(
LEVEL [State Province],
LEVEL [SalesPerson] GROUPING,
LEVEL [City],
GROUP [SalesPerson].[SalesPerson A]
(
MEMBER [HiddenCustomers].[CA].[Altadena],
MEMBER [HiddenCustomers].[CA].[Beverly Hills],
MEMBER [HiddenCustomers].[CA].[Bellflower],
MEMBER [HiddenCustomers].[CA].[Daly City],
MEMBER [HiddenCustomers].[CA].[Fremont],
MEMBER [HiddenCustomers].[CA].[Concord]
....
),
....
)
)

Here, I'd like to specify member list within GROUP more effectively. For
example,

SET Filter( [HiddenCustomers].[CA].Children, <<Condition>>)

But looks like that current AS does not support this kind of syntax. Any
ideas?

Thanks in advance,

Ohjoo Kwon