Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Hide folders based on roles

    Posted 07/29/20 05:34 AM
    I have a folder "Data Sources" where all data modules are stored which was created by admin.
    I have hid this folder from users using "Hide this Entry" option in properties.
    Now, we also have some powerusers who can upload files and create their own data modules and publish reports.
    The poweruser wants to hide the folder in which they had uploaded the files & created data modules and only the reports folder should be visible to the user.
    But if I give these poweruser the option of "Show hidden entries" then they will be able to see the folder("Data Sources") that was created by the admin.
    Is there any way I can hide the folders that was created by admin or hide the folder based on roles?

    ------------------------------
    Vaibhav P
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Hide folders based on roles

    Posted 07/30/20 07:24 AM
    Hi Vaibhav
    You should use security via a Group to accomplish this task. 

    This should give you enough information to get you started.
    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_accesspermissions.html
    Cheers,
    Trevor

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



  • 3.  RE: Hide folders based on roles

    Posted 07/30/20 08:39 AM
    I'm not sure there's a good way to do this. As far as hiding entries, it's an "all or nothing" as far as I know. You could try setting up a group or role that doesn't have access to the "Data Sources" folder, but I think that's going to keep them from being able to use it. It might be that you could use "traverse" and "execute" on the "Data Sources" folder to accomplish what you want, but I think you can still see the folder if it is set to traverse.

    ------------------------------
    Jonathan McKnight
    4x IBM Champion, Data and Analytics
    http://www.linkedin.com/in/jonathanmcknight
    ------------------------------



  • 4.  RE: Hide folders based on roles

    Posted 07/30/20 02:54 PM

    I know back in Cognos 10 we used the method at the bottom of this document. Essentially you were required to have Read access to see the Folders but the users were only given Traverse and Execute.
    I just tried this now and it did work for me in Cognos 10. I've not been able to get it working in CA 11, I'll see if there is something comparable in CA11.

    https://www.ibm.com/support/pages/package-permissions-errors-qe-def-0157



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



  • 5.  RE: Hide folders based on roles

    Posted 07/30/20 02:58 PM
    Edited by System Admin 01/20/23 04:27 PM
    Answering my own question, this is the new method. I've not tried it but I probably will when I have some time.
    https://www.ibm.com/support/pages/portal-visibility-filter-cognos-analytics

    In newer versions it can be changed here: 

    Manage -> Configuration -> System -> Advanced Settings


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



  • 6.  RE: Hide folders based on roles

    Posted 07/30/20 03:09 PM
    Be aware that anyone who has access to your datamodules can modify them by copying them to my folders.

    Access to public folder can be controlled well and without any problems by groups.

    Only problem is my folder.

    My suggestion, don't use datamodules unless you have a data security in the database.

    11.1.7 still has this flaw.

    ---
    .... sent from mobile ... excuse my brevity.





  • 7.  RE: Hide folders based on roles

    Posted 07/30/20 03:27 PM
    Hi,

    IBM has implemented a feature that we can give access to users to run reports based on data modules, but can not edit or copy.

    I asked IBM for it and has implemented on version 11.0.13.

    You have to only grant execute and traverse to data module and data sets (case exists) and reports to users that cannot see the data.

    You may apply security filters on data modules or reports, it is up to you.

    ------------------------------
    JEAM COELHO
    ------------------------------