dsabi on Sun, 27 Jul 2014 06:32:57
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
For the difference between FILTER and WHERE, here is a similar thread which describe the difference between them, please refer to the link below.