If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Using cam_passport in COGNOS 8

Started by ckporter, 24 Jul 2007 08:47:55 AM

Previous topic - Next topic

ckporter

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

COGNOiSe administrator

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

rkopp

if you want to change data  - why not using addons like Apparo Fast Edit?

tmacfarlane

hello, what about using the Cognos SDK to pass the value via a webpage?

http://bicentre.blogspot.com


COGNOiSe administrator

SDK wouldn't help, since the requirement is from the report out. SDK mostly works from the outside in. Oh, and it costs $$$.

lindero

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


bpeterson

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.