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.
hello govind
ReplyDeletei allready write to you yesterday about sharing
solution details but forgot to put my email
address:
emails4ayelet@gmail.com
we will appreciate very much your help.
our company have a lot of users who need the
facility of write back to database.we are using cognos 8.4 and sqlserver 2008.
regards,
ayelet ronkin from egged transportation company
Hi .. I have sent you the email on june 1. I have developed the solution for oracle database. For SQL server you can find the code in cook book also ,
DeleteHope that helps..
Hello Govind ,
ReplyDeleteReally it very nice i am appreciating you. Same solution i need develop in my project ..so can you please share this solution details with me
My Email id: mvn.balu@gmail.com.
Thanks & Regards
balaji
Hi .. Shared the solution on your email..
DeleteThanks
Govind
Thanks Govind
ReplyDeleteHi Govind ,
ReplyDeleteI need to create write back option in cognos 10 can u guide me how to achieve this please
Hi Govind,
ReplyDeleteI have a requirement where the user needs to delete the records from the database. The solution which you have mentioned will be very helpful. Can you please share the same : dsg.cognos@gmail.com
Thanks
dsg
Thanks for your posting , which helped me to join cognos online training @ www.monstercourses.com
ReplyDeleteHi Govind ,
ReplyDeleteI have the same requirement to develop the report can u guide me how to achieve this please. please provide the solution or mail to this id srikanthshonti@gmail.com
Hello Govind,
ReplyDeleteCan you share your Idea with me? I have a requirement for similar Request.
mahejntu@gmail.com
Appreciate your help.
-Mahe
hello Govind
ReplyDeleteim intersted if i could create a report studio 10 that will enable a user to update a specific table from oracle that used in the same report studio output.
thanks in advance
guybm10@gmail.com
Hi Govind,
ReplyDeleteI do have the same requirement(Write back to Database) in my project. Could you please share me the solution with me.
Appreciate your response.
samgovind@gmail.com
Thanks,
Govind
Hi Govind,
ReplyDeleteCan you please forward the solution to me? I will be thankful to you.
thanks,
Suresh.
Hi Suresh,
DeleteYour email ID pls..
Regards,
Govind
Hey Govind,
ReplyDeleteCan you please send the solution to myself at namlee@gmail.com
Thank you
can you please send me the solution at keerthana.ak@gmail.com
ReplyDeleteHey Govind,
ReplyDeleteCould you please send the solution as steps and how you achieved this in cognos 8 as I have the same requirement in my project?
Thanks,
Raghav
Sorry forgot to give my id in the above message. It's t.sudharsan@gmail.com
DeleteHi,
ReplyDeleteWas looking for a similar solution for my project, can you please share the code with me, my id sreeparam@gmail.com
Could you send me the solution? mailmic@gmail.com
ReplyDeletePlease send me this solution (does it write multiple values to database at once?): katoji@yahoo.com
ReplyDeleteThanks
can you send it hkg198282@gmail.com please
ReplyDeleteHi govid,
ReplyDeletecan you please send it to pavankumar.kandimalla@gmail.com
similr kind of functionality needed, but we have to deliver the reports with in the 5 days. please help me
Hi govid,
ReplyDeleteCould you please send it to mtkoua99@gmail.com? Thanks.
Hi Govind,
ReplyDeleteCould you please send the solution to akshay0205@gmail.com
Appreciate your help. Thanks
Akshay
Hi Govind,
ReplyDeleteCan you please send me the solution to mounika.g@ge.com
I had same requirement to complete.
Thanks,
Mounika
Hey Govind,
ReplyDeleteCan you please send the solution to myself at dudik.miro@gmail.com
Thanks a lot!
Miro
Hi Govind,
ReplyDeleteCan you please email me the solution to monisha4b9@gmail.com
Thanks a lot!1
Regards
Monisha
Hi Govind,
ReplyDeleteYour solution looks great. I am also facing a similar situation. I am also using Oracle DB. I would really appreciate if you could share the solution with me. My email id is sharma.parin@gmail.com
Thanks a ton
Parineeta
Hi Govind,
ReplyDeletePlease share the solution. I have same requirment in my project as well.
Thanks and Regards,
Navdeep Kaur
email : navdeepkaur.bhamra@gmail.com
Hey Govind if you would be so kind as to share this with me? Is there any changes needed for C10, or does it work as expected in 8 or 10? Thanks!
ReplyDeletejsj674@gmail.com
Hey Govind ,
ReplyDeletePlease share the solution .
Email Id monigarishiva@gmail.com
Hi Govind!
ReplyDeletePlease share the solution!
Email: elinigor27@gmail.com
Thank you!
hi govind,
ReplyDeletecan you please share the solution on chitresh86@gmail.com
thanks
chitresh
Hi Govind,
ReplyDeletecan you please share the solution on gprcog@gmail.com
Hi Govind,
ReplyDeleteCan you please share solution on shivaram.bi@gmail.com
Hi Govind,
ReplyDeleteI am facing the same issue for which you have a solution....I am working on Oracle Database...Can you pls share the code so that I can use it at my end....Its urgent..
Hoping a positive response...
Regards,
Sandeep
My Email ID is nairsandeep8688@gmail.com
ReplyDeleteHi Govind,
ReplyDeleteCould you please send the solution to my email? at pwkoot@gmail.com
Thanks,
James
sorry, forgot to inform you in my earlier post that I need the oracle solution. btw, that's a brilliant solution you have there for a cognos write-back. Cheers.
ReplyDeletepwkoot@gmail.com
Could you please send the solution to my email? at chitramadabushI@gmail.com
ReplyDeletecan you please share it to the mail id shiva.ababsap@gmail.com
ReplyDeletecould you please share to mayuri.bandaru@gmail.com.
ReplyDeleteThanks in advance
This comment has been removed by the author.
ReplyDeleteHi Govind,
ReplyDeleteCan you please share the solution with oracle,need urgently!!
Thanks
Hi Govind,
ReplyDeleteCan you pls. share the code as looking for the cognos write back in oracle database...
Need urgently!!!!!
This is my email: lanyprasad@gmail.com
I am using cognos to write in Oracle database and it is not working would you please send me the solution doc! My email is dipensunu@gmail.com
ReplyDeleteI am using cognos to write in Oracle database and it is not working would you please send me the solution doc! My email is dipensunu@gmail.com
ReplyDeleteHi, Could you please share the solution as we have the similar requirements? My email is tedliu2000@gmail.com
ReplyDeleteThanks a lot !
Hi, Could you please share the solution as we have the similar requirements? My email is yogiraj01@gmail.com
ReplyDeleteHey Govind,
ReplyDeleteCan you please send the solution to myself at gazitshahar@gmail.com
Thank you
Hi Govind .. Can you please share the solution we have the similar requirements praveensakhamuri007@gmail.com
ReplyDeleteHi Govind .. please share the solution we have the similar requirements rpachava@gmail.com
ReplyDeleteHi Govind, my email is bisret@gmail.com , can you please share the solution.
ReplyDelete