COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: erics on 09 Feb 2015 02:37:38 PM

Title: Dynamic data by user
Post by: erics on 09 Feb 2015 02:37:38 PM
Hi there,
I've inherited Cognos, and still waiting to be trained on v10, only worked on 7 or 8.
My boss is asking me to give users permissions to certain pages, but that based on their username they see different data.
For example user A sees the data for Canada, user B for the US, and user C for North America.
Is that possible? And how?
I assume that it's somehow with filters, but don't see anything in the current code ...
Title: Re: Dynamic data by user
Post by: Robl on 10 Feb 2015 09:16:56 AM
My first question would be whether this is for securty or convenience.
Because report level filters like this aren't secure in the grand scheme of things.
It's much more common to put the data level security in place in framework manager.

That said, there are somethings you can do.
In the report query create a new data item.
On the 5th tab along the bottom you will see a tab called Macros.
Within this is a section for session parameters.
In here you'll find information about session ID, user name and so forth.

You can use this to create data items to filter against.