KB320795: After unselecting the first element of a checkbox selector, the selection type will change from “Include” to “Exclude” in MicroStrategy Web 10.3 – 10.5

Description

After running a document, when the first element of a checkbox selector based on an attribute that has at least 1,000 elements, if the Selection type has been set to “Include,” this will be changed to “Exclude.”

Steps to Reproduce

1. In Strategy Tutorial create a report that contains Customer and Cost.
2. Create a document based on the previous report and add a grid with both attributes and a check box selector for the Customer attribute, making sure the “Show option for All” and Selection Type of the selector is set to “Include” as seen below:

1. Run the document and uncheck the first attribute element in the selector, you will notice that the selector will change to exclude mode.

Why is this happening?

This is an expected behavior due to an initial database limitation that occurs when the number of selections is greater than 1,000. The Selection type is changed to Exclude in an effort to filter the the data efficiently.
 

Solution

If you want the Selection type to remain in Include mode, consider using a dataset with less than 1,000 elements as your checkbox filter. Alternatively, you can choose another filter format, such as a search box.

Workaround

As a workaround, use a filter to reduce the number of attribute elements to be less than 1,000.