HI All, I need to write MDX query ,i have just write the sql query below. select date from tablename where date<=@date and Scheduledtime>0. This query is in SQl ,i want to write the same in MDX. IN SSAS --- Date is Dimension, Scheduledtime --Measure @date - date which we suppose to provide as filter Amit

Here is the sample query . What ever inside the strtomember function is the date parameter to be passed SELECT {(null)} ON 0, FILTER ( {[Date].[Date].[null]: strtomember("[Date].[Date].&[20050724]")} , ([Measures].[Internet Sales Amount]>15000 )) ON 1 FROM [Adventure Works]