COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bpothier on 29 Aug 2012 11:33:35 AM

Title: RESOLVED Session Variable and Report generation
Post by: bpothier on 29 Aug 2012 11:33:35 AM
I am wondering if it is possible to do the following:

User logs into cognos
User picks a report to run
report is run for him only without a prompt by using session variable or something.

Basically capturing their login information and using that as the default variable when they run reports so they don;t continually have to select their name from a drop down list
Title: Re: Session Variable and Report generation
Post by: MFGF on 30 Aug 2012 04:17:49 PM
There is a session parameter which you may be able to use - $account.defaultName - you will need to have a macro somewhere to reference it.

Regards,

MF.
Title: Re: Session Variable and Report generation
Post by: bpothier on 04 Sep 2012 09:40:52 AM
Here is what I did

I created a calculated field in framewrok manager for the query subject I needed it in
Then I created a filter on the report that matched the value returned in that field with one in the report that contained the same data

works like a charm

thanks