Dynamic data by user

[erics]

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 ...

[Robl]

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.