There are times when the values in a table we need to filter on are stored as all-caps. If we supply the filter value via a Cognos prompt, we need to convert the input from the prompt to uppercase before we can make the comparison. This is usually done via the Cognos upper() function. A… Read More »
The prompt controls and interfaces provided in Cognos BI Report Studio are limited and a bit old-fashioned. In fact, the look and feel of these controls has not changed much in the last decade in which I’ve been working with the tool. Meanwhile, Web interface look and feel has advanced considerably. Modern users expect more… Read More »
In Report Studio, Cognos provides two types of prompt validation: required and numbers-only. The validation options are available in the prompt property page: Required validation checks to see that the prompt in question is not empty. Numbers-only validation checks to see if the contents of the prompt contains only numbers. If either configured validation check… Read More »
In Cognos text prompt interfaces come in two major forms. There is the standard single-value text prompt: …and the multi-value text prompt: If you want your user to be able to enter multiple text values in a single prompt the multi-value text prompt interface is the only option available out of the box. This interface… Read More »
For most prompt types in Cognos there is a Default property that allows for setting of static prompt defaults. This allows you to put in a specific value in advance and it works as advertised. However, there are many use cases where we want to dynamically set the default values to make the prompt interface… Read More »
An important part of the process of working with the Cognos JavaScript API is creating variables that reference the JavaScript objects that Cognos creates to represent the prompts on the page. It’s via these variables that we manipulate the properties and call the methods on the prompt objects. This post will detail a technique to… Read More »