An often requested feature in Cognos is the ability to make a list with expandable rows. There are a few different scripts to support this in Cognos 10, but they do not work in Cognos Analytics.

A well designed page should include some form of notification explaining why certain actions are, or are not working.  So let’s dive back into some custom JavaScript in Cognos to resolve.

In the previous article, we talked about controls via custom javaScript in Cognos Analytics. We created a select prompt that dynamically generates list of field names in a specified list, and allows the user to toggle the visibility of individual columns. In this article, we’ll spend some time on date prompts and datasets and look at cases where we don’t need to generate an interface control, and go over a practical example.

In every new release of Cognos, there are some ups, and there are some downs. And while some people may have a lot to complain about in Cognos Analytics, there are some shining advances that force me to forgive all the questionable design decisions (even the loss of the menu and button bars in Report Studio).