Cognos only supports two type of text box prompt validation; required and numbers only. In both cases Cognos evaluates the text input in real-time. If the validation fails, the prompt gets an orange dashed line underneath it and the Finish button is grayed out. The required validation fails if the prompt is empty and the… Read More »
Cognos value prompt defaults can easily be set to static values. However, if you wanted to dynamically set their default values you had to employ JavaScript code on the prompt page. In fact, I have a tutorial that explains how to use JavaScript to set date prompts dynamically here. You could use a similar technique… Read More »
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 »
Performance tuning is an important part of any Cognos report development project. A report that runs fast provides better user experience and therefore produces happier customers. There are two main ways to time reports in Cognos, out of the box: Run the report and manually time with a stop watch, either physical or virtual Schedule… 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 »
Welcome to cogBlogger. This site is dedicated to advanced Cognos BI report development with emphasis on custom JavaScript enhancement. Feedback is welcome.