hi,my two dimensions and measure: Dimension:GeographyWashington Seattle SeattleArea1 SeattleArea2 SeattleArea3 ... Spokane SpokaneArea1 SpokaneArea2 ...California Los Angeles ...Arizona ...Dimension: Time Year Month Day With measure [Measure].[Order Quantity] and time dimension for year 2012 I would like to get: TotalSum of number of orders (break down by states (washington, California, Arizona,...)) but without SeattleArea3 and SpokaneArea1 SELECT [Time].[TimeDim].[Year].[2013] ON COLUMNS ,non empty(Except ( {[Geography].[DimGeography].children}, // all the regions {[Geography].[DimGeography].[State].&[Seattle].&[SeattleArea1]} ) ) ON ROWS FROM [AdventureWorks] WHERE ([Measures].[Order Quantity]); This query does not take into consideration the exclusion from all the geography the seattle;SeattleArea1. Do you have any ideas how to solve this?
exclude
Posted - 2013-01-03 : 15:40:09