Difference between WHERE and FILTER in SSAS

Category: sql server analysisservices

Question

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?

Thanks

Replies

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.
http://social.msdn.microsoft.com/forums/sqlserver/en-US/5a70da53-7f99-46d3-a4d5-9842ab4e0b84/what-is-difference-between-filter-and-where-condition-in-mdx

Regards,