Thursday 6 October 2011
Monday 26 September 2011
Freeze Report Header in Report Studio
Using Java Script for List and Crosstab :
http://www.ibm.com/developerworks/data/library/cognos/page242.html
Without JavaScript :
http://www.ibm.com/developerworks/data/library/cognos/page242.html
Without JavaScript :
Wednesday 7 September 2011
Write Back to database through cognos 8 series interface !!!
Problem Description :
There are requirements from the client to have the facility to write back to the database specially to capture user input in the form of comments from cognos Report studio .
There is no direct facility to capture user input in cognos 8 series and the solution is a work around for write back in cognos with limited scope.
In Cognos 10 adding user comment is a new inbuilt feature , so this description is helpful for Cognos 8 users.
For Cognos 10:
http://www.citagus.com/citagus/blog/collaboration-in-cognos-10-comments-in-saved-report-output/
Solution Description :
The solution is designed for Cognos Report studio with Oracle Database . It uses stored procedure ( containg input parameters to capture users comment and uniquley identify the record ) returns the resultset in the form of cursor.
The created stored procedure and the table to be updated is imported in frame work manager . The package is published and two reports are bulit using them .
The first report say "Report_1" is designed ( the source of this report is table which is to update ) with a drill through to second report say "Report_2" ( the source is Stored Procedure which updates the table ) .
In the drill through column of the first report we will pass the dataitem value to identify the unique record and give the option of "Do not pass the parameter" for the comment section. Due to above setting the procedure which accepts the parameter of uniquely identifying the record and comment parameter will wait till the user gives the input in the comment section .
Once the user gives the comment input through the pop-up screen which appears due to the drill through facility and clicks ok , the input is updated in the table through stored procedure and the output result set is returned in the form of cursor.
Solution Tools and Database used:
Oracle 11i , Cognos 8.4.1
Solution Screenshot:
Acheivement :
A Technical solution design paper was published by me on this topic.
The solution was well appreciated by the client and also, by the technical experts.
Solution Details :
Will be shared on email on demand.
Leave your comment with email id to view its solution.
There are requirements from the client to have the facility to write back to the database specially to capture user input in the form of comments from cognos Report studio .
There is no direct facility to capture user input in cognos 8 series and the solution is a work around for write back in cognos with limited scope.
In Cognos 10 adding user comment is a new inbuilt feature , so this description is helpful for Cognos 8 users.
For Cognos 10:
http://www.citagus.com/citagus/blog/collaboration-in-cognos-10-comments-in-saved-report-output/
Solution Description :
The solution is designed for Cognos Report studio with Oracle Database . It uses stored procedure ( containg input parameters to capture users comment and uniquley identify the record ) returns the resultset in the form of cursor.
The created stored procedure and the table to be updated is imported in frame work manager . The package is published and two reports are bulit using them .
The first report say "Report_1" is designed ( the source of this report is table which is to update ) with a drill through to second report say "Report_2" ( the source is Stored Procedure which updates the table ) .
In the drill through column of the first report we will pass the dataitem value to identify the unique record and give the option of "Do not pass the parameter" for the comment section. Due to above setting the procedure which accepts the parameter of uniquely identifying the record and comment parameter will wait till the user gives the input in the comment section .
Once the user gives the comment input through the pop-up screen which appears due to the drill through facility and clicks ok , the input is updated in the table through stored procedure and the output result set is returned in the form of cursor.
Solution Tools and Database used:
Oracle 11i , Cognos 8.4.1
Solution Screenshot:
Acheivement :
A Technical solution design paper was published by me on this topic.
The solution was well appreciated by the client and also, by the technical experts.
Solution Details :
Will be shared on email on demand.
Leave your comment with email id to view its solution.
Subscribe to:
Posts (Atom)