Would anyone happen to know whether it is possible to access the user name in Cognos Connection, and pass it to another environment, like Oracle forms or APEX?
We are trying to implement a solution where a link from a report page provides users with a web form interface to interact with an Oracle database. The way in which a user is allowed to alter the DB should depend on their COGNOS credentials (user name in particular).
Thanks,
Chris
If it is just a a user name that you need for the link, then you should be able to use $userName macro in the report as a calculation
if you want to change data - why not using addons like Apparo Fast Edit?
hello, what about using the Cognos SDK to pass the value via a webpage?
http://bicentre.blogspot.com
SDK wouldn't help, since the requirement is from the report out. SDK mostly works from the outside in. Oh, and it costs $$$.
Hey guys,
I don't know if i understood it correctly but passing Cognos8 environment parameters like userName, cam_passport, etc. to an outide application is described in SDK Developer Guide in chapter 9.
Perhaps a look into it helps.
cheers,
Olli
If I understand the problem correctly, this maybe a viable solution. Oracle provides a procedure, APPS_INITIALIZE which will allow the cam_passport information to be passed to the DB and then is transformed to represent the actual user and not the user defined in the data source connection.