I want to be able to filter on a dynamic list of values. For example, I may want to run a report in BIA that filters on a list of Employee Numbers that I have pulled out of an Excel document that I can paste into a filter, or I may want to filter on a list of jobcodes or pay grades. These lists could be up to a 1000 values (Oracle in list limit). I don't want to select each value from a prompt but would rather want to paste a list of values. Is there a "user-friendly" way of doing that?
Not Workspace, but RS and it's a starting point.
How to filter using a textbox input and CSV values
http://www-01.ibm.com/support/docview.wss?uid=swg21342203
What about Cognos 10? I see the link is for Cognos 8.
It turns out the Cognos 10.1 BIA does not have this feature BUT Cognos 10.2 does. In 10.2 BIA was renamed to Cognos Workspace Advanced and it will allow you to paste values into a Custom Filter.
See step 5 in the following link:
http://pic.dhe.ibm.com/infocenter/cbi/v10r2m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_rptstd_fin.10.2.0.doc%2Ft_bia_filter_custom.html&resultof%3D%2522%2563%2575%2573%2574%256f%256d%2522%2520%2522%2566%2569%256c%2574%2565%2572%2522%2520
Unfortunately, it won't allow someone that uses Cognos Workspace (not Advanced) to paste values into a prompt when running the report. I submitted a feature enhancement request to IBM Cognos.