Cognos Analytics

Cognos Analytics

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

 View Only
Expand all | Collapse all

how to make Data module read/run only

  • 1.  how to make Data module read/run only

    Posted Tue August 23, 2022 02:04 PM
    We have a data module and i want to make it read and execute only it should be editable only by admins. Users who have Data module author access should not be able to copy to there mycontent or edit joins etc. How can we achieve this?

    ------------------------------
    Vijay V
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: how to make Data module read/run only

    Posted Wed August 24, 2022 08:33 AM
    If the user has access to the Data Module object, and they have the capability to copy objects or make data modules I don't think there is a way to stop them from copying it to their My Folders. In situations like this I would recommend moving the data module to a hidden folder. Create a report and dashboard attached to the module and save them in an accessible location. 

    Finally you need to prevent users from viewing hidden objects - go to Hide Entries in capabilities under Security.


    Set Execute and Traverse on the groups/roles you want to hide the module from. 



    The users will be able to use the report/dashboard as the basis for whatever analysis they need to do, but they won't be able to see or interact with the underlying data module any way.

    ------------------------------
    Paul Mendelson
    ------------------------------



  • 3.  RE: how to make Data module read/run only

    Posted Wed August 24, 2022 09:49 AM
    Thank you Paul, If i implement above solution will users still be able to create new dashboards/reports? based the hidden DM.

    ------------------------------
    Vijay V
    ------------------------------



  • 4.  RE: how to make Data module read/run only

    Posted Wed August 24, 2022 02:37 PM
    They wouldn't be able to make new reports or dashboards, but they can take the existing ones that you've made as the base and go from there.

    ------------------------------
    Paul Mendelson
    ------------------------------



  • 5.  RE: how to make Data module read/run only

    Posted Thu December 08, 2022 08:44 AM
    Edited by System Admin Fri January 20, 2023 04:51 PM
    Hi Paul, we need exactly the same as Vijay. Why does not the READ permission for Data modules provide it? Or some other CUSTOM permission mixture? I did not find any difference between READ and RUN permissions for Data modules. The users would see it, could use it as a source, but could not copy it out and remove joins (security). This is really blocking point of using it as Self-Service source. Is there any APAR to vote for? Another point for end users to complain about rigidity of Cognos and moving to PowerBI :(

    ------------------------------
    Josef Minarik
    https://www.linkedin.com/in/josef-minarik/
    ------------------------------



  • 6.  RE: how to make Data module read/run only

    Posted Tue December 20, 2022 04:52 PM
    Yes this is an important feature.   @SAMI EL CHEIKH and I should have some updates related to this feature sometime in the near future. Can you all comment about what version of Cognos you're running? Thanks! ​

    ------------------------------
    Zachary Taylor
    ------------------------------



  • 7.  RE: how to make Data module read/run only

    Posted Wed December 21, 2022 10:03 AM
    I'm running into the same issue as mentioned here. We are running a multi tenant environment with over 120 tenants and 1300+ users. We built a data module based on the content store and audit store to give users the ability to get insights about the authorization and use of Cognos. 

    Now we would like to give some of the users the rights to create data modules themselves. We're not able to grant these rights due to the fact that they are able to edit the data module I just mentioned as well. The option to hide items and prevent users from revealing these hidden items is not a feasible option for us as well. The more advanced tenant users have the ability from hiding and unhiding objects within their tenant. Consumers do have the ability to show hidden objects but authers do.

    As mentioned by @Josef Minarik​​​ Cognos should make a distinction between the read and execute permission similar to how it works for accessibility to datasources. With the execute permission you are able to use a data source but without the read permission you are not able to read the schema-content which give you the ability to built datamodules on top of that data source. This is very helpful. Run permission on a data module should give you the ability to use a datamodule where the Read permission should give you the right to read it in the data module editor. At the moment you need both permissions to even use a datamodule to built reports or dashboards.

    @Zachary Taylor, we are running release 11.1.7 in production and 11.2.3 in test. Related to this topic both release work the same. Hopefully you can give this issue some priority. Or a least help us finding the proper Idea to vote on. If there is any workaround available that would be great of course.​

    ------------------------------
    Michiel Schakel
    ------------------------------



  • 8.  RE: how to make Data module read/run only

    Posted Thu December 22, 2022 07:20 AM
    Hi @Zachary Taylor, we are running release 11.2.2 

    ------------------------------
    Josef Minarik
    https://www.linkedin.com/in/josef-minarik/
    ------------------------------



  • 9.  RE: how to make Data module read/run only

    Posted Wed January 04, 2023 05:29 PM
    Thanks @Josef Minarik!​

    ------------------------------
    Zachary Taylor
    ------------------------------



  • 10.  RE: how to make Data module read/run only

    Posted Wed January 04, 2023 05:30 PM
    Edited by System Admin Fri January 20, 2023 04:43 PM
    We plan to have something for this in an upcoming release, but if you'd like to help us with a beta test, feel free to send me a direct message and we can work on setting something up. @Josef Minarik and @Michiel Schakel
    ------------------------------
    Zachary Taylor
    ------------------------------



  • 11.  RE: how to make Data module read/run only

    Posted Wed May 14, 2025 08:32 AM

    Has there been any update to this? 



    ------------------------------
    Will Phillips
    ------------------------------



  • 12.  RE: how to make Data module read/run only

    Posted Tue January 03, 2023 09:50 AM
    We just upgraded to 11.2.4, and I would love to have this feature.

    What we do now is similar to what Paul mentioned above, but we have anyone who wishes to create reports added to a new security group and have them follow instructions to show hidden entries when going through training on developing reports.

    ------------------------------
    Jonathan McKnight
    5x IBM Champion
    Business Intelligence Analyst
    Nashville, TN
    www.linkedin.com/in/jonathanmcknight
    ------------------------------



  • 13.  RE: how to make Data module read/run only

    Posted Thu December 22, 2022 12:51 PM
      |   view attached

    Hi Josef,

    Does the Permissions filter help with your scenario? I've created a document to show it in practice. 

    Not sure if you have considered this feature and previously dismissed it. I don't see any reference in the thread.



    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 14.  RE: how to make Data module read/run only

    Posted Mon January 09, 2023 02:28 PM

    Hello Trevor,

     Many thanks for the guide. I would have a couple of questions:

    1. The „Permission filter" you are referring to, is this a part of the Administration interface? If so, where exactly should I look for?
    2. According to your guide, setting Traverse and Execute (and leaving Read on default) on the folder containing the data module will prevent user to see the folder, however that's not the case, the user can still see the folder. Has this something to do with the „permission filter" you mentioned?

     As of now, the only way to prevent the user to get into the data module is to deny the Read right on it, however any dashboards using this data module as a source will not display (unable to load metadata…).

    It does work for reports though.

     We are still looking for a solution that prevents the user to get into the data module, but enables him to use this data module as a source for both dashboard and a report.



    ------------------------------
    Josef Minarik
    https://www.linkedin.com/in/josef-minarik/
    ------------------------------



  • 15.  RE: how to make Data module read/run only

    Posted Mon January 09, 2023 04:14 PM
    Hi Josef,

    1.) This setting is in Manage -> Configuration -> System from the Cognos Portal.

    2.) The user cannot see the folder called Module as they only have Traverse and Execute access. The Permission filter prevents anyone that doesn't have either Read, Write or Set Policy from seeing the folder. 

    This will allow users to use the data module metadata for reports and dashboards but not open the module.  Or see it so it could be copied.

    I am happy to be corrected but as of now I know of no way to open/copy the module as the User in this scenario.

    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 16.  RE: how to make Data module read/run only

    Posted Tue February 07, 2023 11:19 AM
    Hi @TREVOR COMEAU, it works.
    However, it must be set by Cognos admin and it has still limitations ​if I want to use the DM as a source, I have to have dummy report and dashboard. It is good workaround but I would really welcome a proper solution (e.g. utilize READ access) if DM should totally replace Framework Manager. Looking forward to see it in upcoming releases.

    Still thank you a lot!

    ------------------------------
    Josef Minarik
    https://www.linkedin.com/in/josef-minarik/
    ------------------------------