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
------------------------------
Original Message:
Sent: Tue June 02, 2020 07:44 AM
From: Vasudeva Reddy Cheluri
Subject: What best practice are using when setting up data servers for Data Modules?
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
Original Message:
Sent: Mon June 01, 2020 04:43 PM
From: Jo Marie Sellner
Subject: What best practice are using when setting up data servers for Data Modules?
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