One of the reasons for my slowdown in posts, is an increased workload. Fortunately, despite the occasionally bizarre requests I receive, sometimes I get one that is fun. The latest being my client wanted a multiselect autosuggest feature.
Here’s an example of autosuggest features that can be done in Cognos. It works fine, but the issue with that is that it uses the display value, and you can only select one option at a time.
Like the previous solutions, this is also an easy addition.
In general, I try to avoid adding extraneous HTML items, but unfortunately there is no decent way of identifying a prompt object in versions prior to 10.2. A checkbox prompt, when using the normal API, will return a set of its options. If there aren’t any options, fW._oLstChoicesPromptName will return nothing. So, despite my better judgment, wrapping the prompt is required. Also, due to the way certain browsers handle select objects (I’m looking at you, IE), this will only work with radio and checkbox prompts.
If everything works correctly, and everything should work perfectly on the first try, this being Cognos, you should get similar results.
The attached report was built on 10.2.1 on the Sales and Marketing cube, but it should downgrade cleanly to previous versions by changing the schema number in the XML. Have any questions about this? Email us at firstname.lastname@example.org or fill out the comment box below.