Is there a way to configure a query subject so that the user can't use the Filter Conditions dialog in Report Studio or Workspace Advanced?
Why?
As-of 10.2.1 FP 9 (and maybe earlier), there is a bug in the Filter Conditions dialog. If a user tries to filter on a query item that has many distinct values, the Filter Conditions dialog spins up a process that it never kills, even after the user has clicked OK or Cancel. This process requests data from the database, gets it, then tries to format it to display in the list box on the left (Values:). When the list of distinct values is long, this is an expensive process. The user usually enters a search parameter (creating another of these requests) to get a quicker response, or will just use the "New" button to enter their values.
The users never notice this problem and it is not a big problem when it happens once or twice a day. The BI service runs one cpu core at 100% for a while (97 minutes for 264,000 distinct values) for each of these requests. Usually, Cognos distributes the rest of the reporting load to other BI services (I have 4 running) and nobody notices. But when 10 people in a classroom do this at the same time, there's nowhere for that much load to go.