Hello,

I am wanting to get a result set like

Unit Sales
Ca 10
OR 20
Food 30
Drink 40

Ex
with set myset as '{[Store].[All Stores].[USA].[CA],
[Store].[All Stores].[USA].[OR],[Product].[All Products].
[Drink],[Product].[All Products].[Food]}'

Select {[Measures].[Unit Sales]} on columns,
myset on rows
from sales


of course a named set only takes 1 dimensions members.

any ideas

TIA

Steve

Actually, Sets are made up of tuples so this would return what you want, and you can clean up format in the client app

with set myset as '{
([Store].[All Stores].[USA].[CA],[Product].[All Products])
([Store].[All Stores].[USA].[OR],[Product].[All Products])
([Store].[All Stores],[Product].[All Products].[Drink])
([Store].[All Stores],[Product].[All Products].[Food])}

Select {[Measures].[Unit Sales]} on columns
myset on row
from sale

HTH
Bria
www.geocities.com/brianaltmann/olap.htm