Hi,



According to my knowlege the WHERE clause of MDX Queries

expects a touple in front of it.



The .item(0) function returns a touple from a set according to

definition. (there is another variation of .item that returns a member

from a tuple).



There ORDER() function returns a set.



My question is when i execute the following query,



SELECT TIME.YEAR.MEMBERS ON COLUMNS FROM SALES

WHERE ORDER(market.region.members, measures.sales).item(0)



it gives the error :-



Unable to open cellset

Syntax error, expecting end of statement

but found extra text, near: '.item(0)'



But when I execute the following , it executes it succesfuly. (I just

added open bracket before ORDER and another close bracket after

..item.



SELECT TIME.YEAR.MEMBERS ON COLUMNS FROM SALES

WHERE (ORDER(market.region.members, measures.sales).item(0))





I know that when I explicitly write a single member on axis, i have

to convert it into set by using { } brackets. This means by default

it assumes it a tuple. Then why didnt it assumed it a tuple in the where

clause.



Thanks



Asim Naveed


--
Posted via http://dbforums.com

Hi Asim,
I've tried this query on Foodmart 2000:

SELECT
{[Time].[Year].Members} ON COLUMNS
FROM
[Sales]
where
(Order([Store].[Store State].Members,[Measures].[Unit Sales]).Item(0))

and it works fine!!!

Francesco De Chirico

Yes it executes successfuly, but my question is

why we need to add open and close bracktes. According to syntax

it should run without these brackets



Thanks


--
Posted via http://dbforums.com

Good, good question!!!
I think it's a bug!!
It doesn't work even if you use a StringExpression instead of the IndexValue
and
also if you use StrToTuple() (without the additional brackets).

Francesco De Chirico