hi,
my two dimensions and measure:
Dimension:Geography
Washington
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 - 01/03/2013 : 15:40:09
