Is there only one tuple on where clause when I use MDX to query data?

For exmaple, I can use :

Select ...
where [Grade].[Range]

But if I want to add another restriction like {Area].[Range].
How can I add it?

What you have in your example is a single member, not necessarily a
tuple. You specify a tuple by enclosing a list of members in brackets.

eg.

Select ...
where ([Grade].[Range],[Area].[Range])



Books online in SQL 2000 has a good topic on members, sets and tuples.
It also has some graphics that help illustrate the concepts. The
following is an extract:

an ordered collection of one member from one or more dimensions. A tuple
is used to identify specific sections of multidimensional data from a
cube; a tuple composed of one member from each dimension in a cube
completely describes a cell value. Put another way, a tuple is a vector
of members; think of a tuple as one or more records in the underlying
database whose value in these columns falls under these categories. A
series of diagrams presents different types of tuples.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <euohoYqYGHA.508 (AT) TK2MSFTNGP02 (DOT) phx.gbl>,
flying (AT) wfes (DOT) tcc.edu.tw says...

Thank you very much!


"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam>
???????:MPG.1eaf89861e7c36409898f7 (AT) news (DOT) microsoft.com...