Q1:

The function named "Contains()" is documented in the SQL Server2005 help.
But it doesn't work. It seems that there is not such a function.

Q2:

How can I compute date value in MDX? For example, there is a dimension
[Order].
It has an attribute [Order].[OderDate] . I want to get the members between
some date segmnet such as between '1998-01-01T00:00:00' and three months
after. How to express it ?

Q1: I don't know.
Q2:


WITH MEMBER [TimeSet] as
'{STRToMember("[Order].[OrderDate].&[1998-01-01T00:00:00] :
StrToMember("[Order].[OrderDate].&[" & dateadd("m", 3,
CDate("1998-01-01")) & "]"}'
SELECT ....


You can use a custom member set that dynamically creates your members using
STrToMember function...

"GuoLipeng" <GuoLipeng (AT) discussions (DOT) microsoft.com> wrote

Thank you very much.

"Tim Dot NoSpam" wrote: