Simple question from MDX newbie -
03-07-2006
, 12:58 AM
The following MDX is written by Reporting Services project when I
dragged and dropped from the UI
SELECT NON EMPTY { [Measures].[Order Count] } ON COLUMNS
FROM ( SELECT ( { [Channel].[ChannelID-ChannelName].[All] } ) ON
COLUMNS
FROM ( SELECT ( { [Product].[ProductID-ProductKey].[All] } ) ON
COLUMNS
FROM ( SELECT ( { [Customer].[Current Promoter ID].&[11] } ) ON
COLUMNS
FROM [Cube])))
WHERE ( [Customer].[Current Promoter ID].&[11],
[Product].[ProductID-ProductKey].[All],
[Channel].[ChannelID-ChannelName].[All] )
I see that the SLICERS (ChannelID, ProductID, PromoterID) are repeated
in the WHERE clause and also the FROM (...) ON COLUMNS.
This seems redundant to me. If I keep only the WHERE clause, i.e.
SELECT NON EMPTY { [Measures].[Order Count] } ON COLUMNS
FROM [Cube]
WHERE ( [Customer].[Current Promoter ID].&[11],
[Product].[ProductID-ProductKey].[All],
[Channel].[ChannelID-ChannelName].[All] )
Doesnt it return the same results?
Is there any difference (in terms of query performance) if I place the
slicers here or there?
Thanks. |