Skip to Content
0
Former Member
Apr 21, 2010 at 04:11 PM

Excluded Values Appear in BI Query Results

14 Views

A text file containing 587 material numbers was attached to a query selection screen on the "Exclude single values" tab. The query executed successfully, however, 150+ materials from the exclude file appeared in the results. Investigation into why this happens found:

1. When only 500 materials were imported to the "Exclude single values" tab none of the excluded materials appeared in the results.

2. When more than 500 materials were imported to the "Exclude single values" tab 150+ random materials from the exclude list appeared in the results.

Is there a way to ensure that when more than 500 values appear on the "Exclude single values" tab that none of them appear in the results?