By Deepak Puri,
it is declared that a MDX query like
....
WHERE {[NonSelectedDate].[2005].[Jan].[01]:
[NonSelectedDate].[2005].[Mar].[26]}

does not give syntax error

However, when i tried in AS2000 i got an error message like "Can not convert
set to tuple"

Can i use such syntax in AS2000 also? Otherwise, how can i look for a date
interval in my where condition?

Thanks



--
Necati Sekkeli
CBKSoft
Junior Software Developer

Ok then. I got the point with myself and want to share it in case some other
developers may need.

WITH MEMBER [Time].[Total] AS 'Sum({[Time].[2005].[1]: [Time].[2006].[6]})'

SELECT {....} ON COLUMNS, NON EMPTY {....} ON ROWS FROM My_Cube
where ( [Time].[Total])

Necati Sekkeli
CBKSoft
Junior Software Developer


"necati@cbksoft" wrote:

Hi Necati,

Please note that a set in the MDX Where clause works only in AS 2005,
not in AS 2000.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***