Cognos Analytics

 View Only
  • 1.  Security for tabbed reports

    Posted Fri March 10, 2023 02:45 AM

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


  • 2.  RE: Security for tabbed reports

    IBM Champion
    Posted Fri March 10, 2023 03:32 AM
      |   view attached

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

    Attachment(s)

    xml
    securedTabsReport.xml   2 KB 1 version


  • 3.  RE: Security for tabbed reports

    Posted Wed March 15, 2023 09:29 AM

    Hi Robert,

    Thanks for your time and for detailed explanation .Its working as expected .

    Once again thanks for the solution



    ------------------------------
    Pavithra N
    ------------------------------