I was recently trying to replicate a Query Studio simple range filter on string data in the famous new product Cognos Business Insight Advanced and found that it could not be done simply. You are able to create range filters in Cognos Business Insight Advanced on dates or numeric values. But when you need to filter on account codes stored in strings, this is a problem.
In a Query Studio filter for any data type, you can choose the operation “Is In Range” and you provide the beginning and end range values. In Cognos Business Insight Advanced in the case of string values, you are simply given a list of values to pick. Now this might be possible if you have a very small list. But when you scroll through a large list, every page down loses your previous selection. So there is really no way to do a large range selection, unless you do it little by little one screen at a time. This is a big step down even from Query Studio, which has very basic filter capability itself.
Anyone else run into this problem? I’m curious about any suggested workarounds.
