Cognos Analytics

 View Only
  • 1.  What best practice are using when setting up data servers for Data Modules?

    Posted Mon June 01, 2020 04:44 PM
    ​We are wanting to roll out self service data modules to a group of users.  The users will have access to different subject areas within a warehouse, i.e. subject A, subject B, subject C, etc...  All the tables for Subject A, B and C are in one database and scheme.  About 20% of more of the tables are common across one or more subject areas. 

    In framework manager we have one project with one data source and create multiple packages.  The security is then applied to the package(s).  We limited the number of users that have access to framework manager to less than a hand full.

    When a data server is created, if the user for the data server has access to all tables, then users will be able to see all tables and data across all subject areas.  If we create separate data servers with a separate user who access is limited, we still would have to apply security to the data server so no one accesses a data server they shouldn't.

    Would like to know best practice wish how others are handling this and what are the pro's or con's to your approach?

    Thanks!



    ------------------------------
    Jo Marie Sellner
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: What best practice are using when setting up data servers for Data Modules?

    Posted Mon June 01, 2020 06:31 PM
    • I am creating modules using Data servers and giving access only to Modules to use. If have separate folders for each subject area, then only users of that area will have access to data module.
    • You can control security based on their group in source of Data Module so that other areas data are not visible to user not part of the group. 
    • You may also want to secure datasets in same Subject area wise folder structure.

    Each data module is acting like FM Layer so only final presentation layer is exposed to users. 

    One of disadvantage of this approach is document dependencies between modules.  However, in future, if IBM can add Data Module as dependent object in Search functionality end to end, it will be easier to understand the impact of change in source layers.

    Hope this helps.



    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 3.  RE: What best practice are using when setting up data servers for Data Modules?

    Posted Tue June 02, 2020 11:37 AM
    Hi Jo, 
    we had a similar kind of requirement and we followed as below

    if business users are creating their own data modules then

    1. Create multiple data servers(data source) and load meta data only specific tables which requires for business don't load entire schema.



    If Developers are creating data module, I will follow bellow approach 

    1. create master data module with all superset of tables and create joins
    2. create data module based on master data module, you can cherry pick list of tables from master DM as per your business subject area
    3 This approach will help you to handle database level changes at one place which is in master DM

    Regards
    Vasu


    ------------------------------
    Vasudeva Reddy Cheluri
    ------------------------------



  • 4.  RE: What best practice are using when setting up data servers for Data Modules?

    Posted Wed June 03, 2020 10:54 AM
    I am trying your approach.

    1. Created a data module from a master data module.  It creates a link table. I think it does not impact if we remove the link and keep it as a table. Only It allows us to rename the table after removing the link).
    2. Created a folder for each subject area.  But there is no namespace object available.
    3. I am not able to set up the security either query subject ( table) or query items ( data item). ( I have it in my FM model, within the subject area)
    4. It hides the folder for all users, not for specific user groups.
    5. There is no shortcut to creating a presentation layer like the FM model.

    I also want to similar way like FM and minimize my work.

    1.  How do we import the security groups while developing a data module?
    2.  We have a very simplified  security model in FM ( package level, subject area level and folder level and a few query subject and data level security)
    3.  Can I create like confirmed dimension and share to multiple subject areas. 

    Thanks,
    Ram





    ------------------------------
    Ramanujam Rajagopal
    ------------------------------