Hello,
here is comparitive sql query based on the sales cube from default foodmart
2000 sample catalog

select measures.unit sales , CutomerName from sales
where storeName <> "Store1". Here we are interested in all stores whose name
is not "store1"
..
I understand that select portions would go in the select axis for the MDX
query

i.e. select measures.[unit sales] on columns,
Customers.[Name].members on rows from
sales where ??????

how do I write corrosponding slicer part in the mdx query.

Thanking you in advance.

Santosh

Hi Santosh,

You can try something like this...

With member store.total as 'aggregate({except({store.
[store name].members},{[store].[store name].[store
1]})})' select {[measures].members} on columns,
{[Customers].[Name].members} on rows from sales where
store.total

Cheers,
Sanka

An MDX WHERE clause is a tuple. Since only one member per dimension can go
in a tuple, the only way to do this is by creating a calc member that is an
aggregation of the set, like so:

WITH
MEMBER Store.AggStores AS
' Aggregate ({ [Store Name].Members - {[Store 1]} }) '

SELECT
etc...
WHERE (Store.AggStores)

tom @ the domain below
www.tomchester.net


"santosh" <santoshgujar (AT) ureach (DOT) com> wrote