Annotations In Reports

[dsallow]

I am fairly new to all the Cognos products out there and our organization is wanting more and more dashboard/ drilling type reports.  I have developed some dimensional models and now have given them graphs that drill up and down.  management now wants the ability to place annotations on the graphs and or reports .  For instance finance report shows salaries way  under budget.  Someone wants to be able to provide an explanation so next person that sees the spike sees the comment and does not worry about it.  I also forsee this same issue as we have detail records that users want to explain and possibly in scorecarding.  Do I have to create front ends to store this or can it be stored in Cognos somewhere?  If anyone feels this needs to go to a different forum and can tell me how to do that I would be grateful as well.



Don S

[paddhu]

Bringing stored data from backend and projecting it is what Cognos, and other reporting tools are for. Writing back into the database is for sure asking for more. And that is what is happening nowadays... Anyways, a similar requirement came up in one our projects, wherein users wanted to add comments. After a hectic study and discussion, we agreed upon the use of Javascript to achieve this functionality. But this way, you not only store the data in external files through javascript, but also show them on the report using javascript only; say like a banner created in javascript.