SQLServerCentral / Discuss Content Posted by Vincent Rainardi / Article Discussions / Article Discussions by Author / Filtering Members based on their names from the set(MDX) / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:08:36 GMT20RE: Filtering Members based on their names from the set(MDX)http://www.sqlservercentral.com/Forums/Topic932124-292-1.aspxHope this helps:[code="sql"]CREATE TABLE #Dw(Color VARCHAR(20),[Revision Number] INT)INSERT INTO #DwSELECT 'Black', 9843 UNION ALLSELECT 'Blue', 3970 UNION ALLSELECT 'Grey', (null) UNION ALLSELECT 'Multi', 3926 UNION ALLSELECT 'NA', 28919 UNION ALLSELECT 'Red', 4949 UNION ALLSELECT 'Silver', 3424 UNION ALLSELECT 'Silver/Black', (null) UNION ALLSELECT 'White', 568 UNION ALLSELECT 'Yellow', 4799SELECT Color,[Revision Number] FROM #Dw WHERE Color NOT LIKE 'b%' AND Color NOT LIKE 's%'/*Results:Color Revision NumberGrey NULLMulti 3926NA 28919Red 4949White 568Yellow 4799 */[/code]Thu, 03 Jun 2010 09:41:25 GMTbitbucket-25253Filtering Members based on their names from the set(MDX)http://www.sqlservercentral.com/Forums/Topic932124-292-1.aspxHi All. Can any one help me for this requirement:I have the Query: select [Measures].[Revision Number] on 0,[Dim Product].[Color].[Color].members on 1from [Adventure Works DW]The Result is: Revision NumberBlack 9843Blue 3970Grey (null)Multi 3926NA 28919Red 4949Silver 3424Silver/Black (null)White 568Yellow 4799Now I want to remove the members that name starting with 'B' and 'S". i.e. I want to remove the members Black,Blue, Silver & Silver/Black from the result.Thanks in advance...Thu, 03 Jun 2010 07:30:27 GMTch.ds19