Home Dashboard Directory Help
Search

EXCEPT() with nested FILTER() functions that filter on MEMBERVALUE is not evaluated correctly by BillAnton


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 781854
Opened: 3/21/2013 8:53:19 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

The following set-based logic pattern, where <filter1> and <filter2> are both based on MEMBERVALUE, does not evaluate correctly in SSAS 2012:

EXCEPT( <set1>, FILTER( <set1>, FILTER( <set1>, <filter1> ), <filter2> ) )


However, the equivalent set-based logic pattern, where the nested FILTER statement is flattened out, does evaluate correctly:

EXCEPT( <set1>, FILTER( <set1>, <filter1> AND <filter2> ) )


See this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/c8b34a53-0e4c-43ba-93f7-737e86b4b69e/
Details
Sign in to post a comment.
Sign in to post a workaround.