I'm working with v11.2.3 and getting unexpected results (result set) in a query with nine Detail Filters.
I've successfully tested each filter alone and get the correct result set each time. Even when 6, 7, or even 8 Filters are active, the result sets are correct.
But I get wrong result set when all nine Filters are active. Records which should not be excluded are being excluded even though they were not excluded in earlier tests with fewer than 9 Filters active.
I am using Minimum and Maximum expressions on separate fields in separate Filters. Quite literally, it looks like if I could control the other of the execution of one or specific Filters the results might be correct.
Is there anything that I can do inside of a single Query to influence the execution order of my Filters?
It can't be about order of operation. Filters in Cognos are combined using AND. Draw a Venn diagram where each circle represents the data resulting from a single filter. The intersection of all of the circles is the result of applying all of the filters. If the results look wrong, it is because your filter is wrong.