Thank you so much sir for response.

This is parameterized query to use in SSRS.

Also as suggested, we are trying make the cross join with Brand in Set but we are getting following issue:

The [Measures].[First Invoice Date1] and [Measures].[First Invoice Date2] shows different result even the value passed is same

==============================================================

Code:-

Set test

AS StrToMember('[Time].[Fiscal Hierarchy].&['+ CSTR([Measures].[First Invoice Date].VALUE) +']')

MEMBER [Measures].[First Invoice Date1]

AS test.item(0).name

MEMBER [Measures].[First Invoice Date2]

As StrToMember('[Time].[Fiscal Hierarchy].&['+ CSTR([Measures].[First Invoice Date].VALUE) +']').name

==================================================================

FYI:

The value passing in string [Measures].[First Invoice Date] = 201207 (I.e. July 2012)

But from viewing test set using the [Measures].[First Invoice Date1] shows the Jan 2011 But the [Measures].[First Invoice Date2] shows the correct value as July 2012

Regards,

Amit J