Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Data module 'view'

    Posted Thu March 11, 2021 09:50 AM
    Hello, 
    I am trying to expose only certain parts of a data module to certain user groups.
    For example, I have Sales Fact and some dimension tables and a Purchasing Fact with some dimesion tables. I want to expose the Sales fact + conformed dims only to the Sales Team and the Purchasing Fact + conformed dims only to the Purchasing team.
    This is easily achieved in FM by creating two separate packages from the same model but I am struggling to find the equivalent in Data Modules.
    Thanks for reading,
    Carl

    ------------------------------
    Carl Anderson
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data module 'view'

    Posted Sun March 14, 2021 07:15 PM
    Hi Carl,

    In Framework Manager you could use Object Security to easily achieve this. This feature is one of only a small number that I cannot replicate in Data Modules. Where you talked of creating separate packages you need to think about a Data Module being a package. I would create a data module with just your conformed dimensions in it and use that as a linked data module to your fact data modules with either Sales or Purchasing information in them. In theory then you have two data modules that you use for your reporting requirements and one data module containing the conformed dimensions to save you having to replicate work.

    Step 5 in the link below talks about using a 'linked' Data Module.

    Creating a data module (ibm.com)

    Regards
    Andy

    ------------------------------
    Andrew Copeland
    ------------------------------



  • 3.  RE: Data module 'view'

    Posted Wed March 17, 2021 03:59 AM
    Hi Andy
    Thanks very much for your reply, that seems like a logical workaround.
    Cheers,
    Carl

    ------------------------------
    Carl Anderson
    ------------------------------



  • 4.  RE: Data module 'view'

    Posted Wed May 14, 2025 08:47 AM

    Hi Andrew. Have you been able to figure out how to use a Data Module similar to Framework Manager in which you could use Object Security to make certain things visible, yet executable (traverse) to user roles?



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