InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 22:23:04 GMT20http://www.sqlservercentral.com/Forums/Topic1381494-17-1.aspxHave you had a look at the FILTER function?Wed, 07 Nov 2012 12:41:14 GMTmmartin1http://www.sqlservercentral.com/Forums/Topic1381494-17-1.aspxthanks, let me check out :-)Tue, 06 Nov 2012 23:26:09 GMTnish71http://www.sqlservercentral.com/Forums/Topic1381494-17-1.aspxNish, if thats the case, why not use a Hybrid Query(Mix of MDX and SQL)See this: http://www.sqlservergeeks.com/blogs/suhas/personal/545/sql-mdx-in-one-apartment-hybrid-queryTue, 06 Nov 2012 23:10:52 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1381494-17-1.aspxyou are right Ranuk, thanks for your inputs, but adding "[Reseller].[Business Type].&[Warehouse]" type of condition on member level is easily accomplish but adding <>, <=,>=, AND, OR, CASE stement on that level is not achiving, you can put all this condition at the end of query which will apply to full data set but requirment is to apply conditions on specific member level.Tue, 06 Nov 2012 23:01:54 GMTnish71http://www.sqlservercentral.com/Forums/Topic1381494-17-1.aspxNish, you should create a new meaure For example: WITH MEMBER [Measures].[Test Measure] as ([Measures].[Reseller Sales Amount],[Geography].[Country].&[United States],[Reseller].[Business Type].&[Warehouse])Tue, 06 Nov 2012 22:44:51 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1381494-17-1.aspxHi,i have one MDX query which i am using for reporting, i have around 30 different fields which have different filter condition, below is the examplewith member [Measures].[COLPAS] as'([Measures].[Appointments Count])'member [Measures].[COLPA] as'([Measures].[COL VAL 1],[Garage].[Allow Cross Selling].&[True])'member [Measures].[COLPASC] as'([Measures].[COL VAL 0],[Garage].[Allow Cross Selling].&[False])'..............select {[Measures].[COLPAS],[Measures].[COLPA],[Measures].[COLPASC],.......} on columns,{([Garage].[Company Id].[Company Id].ALLMEMBERS * [Garage].[Garage Id].[Garage Id].ALLMEMBERS * [Garage].[Company Name].[Company Name].ALLMEMBERS ) } ON rowsFROM [CUBE]so question is if i want to apply filter on full query i can put filter condition at the end of query with WHERE which will consider full query for filter but i want to put filter on member level and sample filter condition are follow in SQLformat.AND (AL.CreatedOn >= @StartDate AND AL.CreatedOn <= @EndDate)--------------------------------------------------------------- AND ((@Partner = 0) OR (@Partner = 1 AND A.LeasingCompanyID > 0) OR (@Partner = 2 AND (A.LeasingCompanyID IS NULL OR A.LeasingCompanyID = '-2')))so how can i achieve this.Tue, 06 Nov 2012 04:47:25 GMTnish71