Dear all

I want to select most members of a dimension and to exclude some of them.
For example:
Dimension store has following members:
- st1
- st2
- st3
- st4

now I want to select all stores without st4. What would be the MDX statement
to use?

Thanks for your help,

Marc

Hi Marc,

It sounds like you need to use the EXCEPT function. Here's an Adventure
Works example which returns all days of the week except Wednesday:

select [Measures].[Internet Sales Amount] on 0,
except(
[Date].[Day Name].members,
{[Date].[Day Name].&[4]})
on 1
from [Adventure Works]

HTH,

Chris

--
Chris Webb, MVP
Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk
Blog: http://cwebbbi.spaces.live.com/


"Marc" wrote:

Thanks - the Except Function worked very well!

Best regards,

Marc

you can also use the - keyword:
dimension.members - {member 1, member 2 ....}

"Marc" <Roger_Rombooth (AT) community (DOT) nospam> wrote