Writing back to the database

Writing back to the database is perhaps the most frequently requested functionality by business users—writing some notes or comments back to database, for a particular entry on the report. Though there is no direct functionality provided in Cognos Report Studio for this, it is still possible to achieve it by putting together multiple tools. This recipe will show you how to do that.

The business wants to see sales figures by products. They then want to write some comments for the products from the same interface. The comments need to be stored in the database for future retrieval and updating.

You will need access on the backend database and Framework Manager for this recipe.

Tip

As we are only concentrating on Report Studio in this book, we will not cover the Framework Manager options in depth. The power users and Report Studio developers need not be masters in Framework Modeling, but they are expected to have sufficient knowledge of how it works. There is often...