Thanks Tomislav Piasevoli, for your reply.

When I changed my query to

WITH MEMBER [Dim2].[Date].[MM]

AS

' Aggregate( { [Dim2].[Date].[2007-12-31], [Dim2].[Date].[NULL] } ) '

SELECT

{ [Measures].[A], [Measures]. } ON COLUMNS,

{ [Dim1].[Hierarchy].Children } ON ROWS

FROM

[CUBE]

WHERE

( [Dim2].[Date].[MM]...

Hi Tomislav Piasevoli,

Thanks for your reply.

I have replaced 'OR' with comma (,) and its giving me a different error. Modified query looks like:

and the...

Dan English,

Thanks for your reply.

Can you please post the links to the examples of SCOPE statement.

Thanks,

Raj.