Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Restrict Users from deleting widget filters in Dashboard

    Posted Wed July 15, 2020 11:16 AM
    We have created a Dashboard using a Data module.
    We have created a variable which will store the session user id(login id).
    Using this variable we have created a filter to apply row level security.
    We have used this security filter in each "Local filter" field of the visualization.
    But we have noticed that user is able to hover on the filter and delete this filter. Kindly suggest a way in which we can restrict end user from deleting this pre-defined filter or any alternative way to apply row level security to Dashboards created using Data module.

    ------------------------------
    Vaibhav Pujari
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Restrict Users from deleting widget filters in Dashboard

    Posted Wed July 15, 2020 01:29 PM
    Hello Vaibhav,

    I hope that your day is going well.  This is what I recommend:

    Ensure that each user is placed within a user defined group or one of the built-in groups within Cognos.  You can do this through the Admin Console.  We have stored each username is stored in the database with a pre-defined group name. Each one of those particular group names were added into the Admin Console.

    Next, use some technology to capture to the usersname and groupname at login. You can add new groups - Security Tab>Users, Groups, and Roles>Click on the database>New Group

    Next, access the permission of the dashboard, add the specific group, and modify the setting for that group such as read, run, full, etc. 

    Adding and assigning groups is a detailed process; Therefore, let me know if you require more instructions.

    Warm Regards,
    Eli





  • 3.  RE: Restrict Users from deleting widget filters in Dashboard

    Posted Thu July 16, 2020 06:28 AM
    @Vaibhav Pujari​ - assuming this is a widget that is placed on the canvas.  What we did is more of a work around and sophisticated end users could still find a way to remove the widget.

    Workaround:
    - place a shape (square/rectangle) the size of the widget filter on the canvas
    - ensure it is approximately the same size or a bit bigger
    - change the color in the property setting to be "no color"
    - then place the shape on top of the widget filter
    - ensure that the new shape is in front of the widget filter

    Again, not full proof, but the user cannot click on the widget filter and/or change the filter values or delete the widget filter.

    ------------------------------
    Peter Chan
    ------------------------------



  • 4.  RE: Restrict Users from deleting widget filters in Dashboard

    Posted Thu July 16, 2020 10:28 PM





  • 5.  RE: Restrict Users from deleting widget filters in Dashboard

    Posted Thu July 16, 2020 04:23 AM
    I believe you should be able to apply the filter in the data module itself so that you do not need to apply as a local filter in dashboards. 

    Regards

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------