Merging and filters in BO XI 3.1 SP6

Let’s define two similar queries for 2004 and 2005. The query for 2004 looks like:

pic 1

The queries are merged by Service:

pic 5

Now we want to filter table based on a measure from one of the queries.

Let’s define variable v_Filter as


With the following report filter, the table will show 3 rows and it is expected.


pic 6

But we will get not quite expected results when one of “non-merged” objects is used.

pic 7

With [2004].[Service], the filter will remove only numbers that does not match restriction.

pic 8

With [2005].[Service], the filter will be ignored.

Why? It seems it worked more predictable in earlier versions.