Can you please suggest me the alternate solution of following MDX query issue please its very Urgent:

The following set of COMP_YTD_CP is works fine with single brand but when user selectes multiple brand it always takes min value of the First Invoice Month irrespective of current memebre of the brand For e.g: Brand First Invoice Month B1 201202 B2 201107 B3 201101 B4 201204In this case, for all the brands first invoice date is considerd as 201101 inspite of different first invoice dates mentioned above next to the brand.

Right, this query is pretty static. How are the users viewing the results (excel, a parametrized report etc.) as this will help us answer your question?

On first glance your calculations and sets don't appear to take brand into account. This could be it. However without knowing how the cube is being accessed (and the query that is being sent to the cube) it's difficult to tell.

Note:- In [Measures].[FID] it shows the different Invoice Month for diffrenet currencies irrespective of same brand and country so user requested to get min of FID so created 2nd [Measures].[First Invoice Date].

--If two brads have different FID because of different currency so puting logic to --get Minimum of FID out of multiple FID for diff currencies.MEMBER [Measures].[First Invoice Date]AS MIN(NonEmpty( ( {[Articles].[Coalition Brand].currentmember} * {[Customer].[Sold To Country].currentmember}* {[Local Currency].[Currency].[Currency]} ),[Measures].[FID]), [Measures].[FID])

--If two brads have different FID because of different currency so puting logic to --get Minimum of FID out of multiple FID for diff currencies.MEMBER [Measures].[First Invoice Date]AS MIN(NonEmpty( ( {[Articles].[Coalition Brand].currentmember} * {[Customer].[Sold To Country].currentmember}* {[Local Currency].[Currency].[Currency]} ),[Measures].[FID]), [Measures].[FID])