Dear Pavithra,
you need to set up render variables for your pages.
Let's say we have a report with pages for languages and we want users logged into Cognos with their language to see only those tabs with their appropriate language data.
Go the the variables section and create a string variable. I called mine "TabSecurity" and use "LOCALE()" function to link the variable to the locale of the user. In the Values tab enter a line for each value that you want to assign later to the report tabs. In my case I want three languages.
Now we have to assign the variable to each report page and select for which values of the variable the report page should be rendered.
Finish. When I run the report with German, French or English as language I see different tabs.
You have to change this setup to your desired security approach. You can also use macros or query items in the variables. I assume you have a namespace connected to Cognos where you can capture the group membership of your users. If you need additional attributes, see https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=cccul-making-custom-user-properties-ldap-available-cognos-components
Check the "Session parameters" section in your query when you add new query calculations.
I hope this helps. You can use the test report spec I've attached here.
------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------
Original Message:
Sent: Fri March 10, 2023 02:44 AM
From: Pavithra N
Subject: Security for tabbed reports
Hello Everyone,
We have a report and it has multiple tabs .Say for ex-8 tabs .Based on user we need to provide security on tabs
Example we have 3 users (ie) User1, User2 ,User3
If user1 login into cognos and run the report then they have to see first 4 tabs ,user2 last 4 tabs ,User 3 visible to all tabs.
Please suggest an approach to achieve this
Thanks in advance.
------------------------------
Pavithra N
------------------------------