Hi All i need to create a SSRS report on SSAS cube . i need to select 2 DImenSION values from Parameters . when i select ALL member attribute in dimensions ( Thru report parameter ) , i have observed these results 1. Result set is giving all the combinations including ALL members with other Dimension attributes , But i need only the combination Dim1. ALL,Dim2.ALL 2. In result set Instead of ALL member it is displaying ((Null)) My Question : How to get if i select ALL member in both dimension , i need only Dim1. ALL,Dim2.ALL combination , not all dimension mebers combination.Surendra Thota

Hi Surendra Thota, According to your description, you would like to filter data in MDX query. Please correct me if my understanding is wrong. I suggest you using filter function to achieve you target. Filter function can return the set that results from filtering a specified set based on a search condition. Please refer to the Filter Syntax as below, Syntax: Filter (Set_Expression, Logical_Expression) Set_Expression: a valid Multidimensional Expressions (MDX) expression that returns a set. Logical_Expression: a valid Multidimensional Expressions (MDX) logical expression that evaluates to true or false. Here a example shows the use of the Filter function on the Rows axis of a query, to return only the Dates where Internet Sales Amount is greater than $10000: SELECT [Measures].[Internet Sales Amount] ON 0, FILTER( [Date].[Date].[Date].MEMBERS , [Measures].[Internet Sales Amount]>10000) ON 1 FROM [Adventure Works] For more details about the topic, please the following article, Filter (MDX): http://msdn.microsoft.com/en-us/library/ms146037.aspx If you have any question, please feel free to ask. Thanks, Eileen