New Columns Not Showing Up in Framework

Problem:

For a Query Object in the framework, I added some columns in the database table. When I edit the Query Object in Framework Manager the new column does not show up. Although the SQL I used is “select * from table”. Also validating the object did not work.

Solution:

In the Project Viewer click once on the object. From the toolbar choose “Tools” > “Update Object”. Framework Manager will start verifying the object with the database. As a result the new column will be added to the Query Object.

 

 

Cognos Error RSV-VAL-0032

This article explain how I got Cognos Error RSV-VAL-0032 and solved it.
In a report I have a filter on Date From. It works with a DatePicker Prompt. Often the client wants to print the report or view in PDF. When the report is started and no Date From is chosen, the parameter p_date_from is empty. So when I show this parameter in the report it is empty.
To solve that I created a report expression with the following case:

Continue reading