Difference between WHERE and FILTER in SSAS

Category: sql server analysisservices


dsabi on Sun, 27 Jul 2014 06:32:57

hi experts,

   I am new to SSAS,Can anyone pls help me to know the difference between WHERE and FILTER in MDX?



David Harazi on Sun, 27 Jul 2014 11:02:17

Hi ,

The WHERE clause is used to filter the result's returned records.
The Filter function returns the set that results from filtering a specified set based on a search condition.
* Filter function executes IIf(Logical_Expression, Set_Expression.Current, NULL) on each tuple in the set, and returns the resulting set.
**You can use the Filter function in the Where clause .

Charlie Liao on Mon, 28 Jul 2014 05:53:47

Hi Selvakumar,

For the difference between FILTER and WHERE, here is a similar thread which describe the difference between them, please refer to the link below.