Sutha's SQL BI Blog

MDS System Administrator Tasks

1. Create the dimension models and associated hierarchies, entities and attributes.
2. Manage model versions. This would involve copying versions, locking versions, validate for completeness and committing versions.
3. Manage users. Create users and assign appropriate security.
4. Process staging tables. Populate MDM database with dimension model data.
5. Load MDM data views. Load the model versions into the subscribing systems to be viewed.
6. Format and input data. Format the data from the source systems and populate the MDM staging tables with the dimension model data. 
7. Manage business rules. Create and manage business rules to enforce corporate wide standards. Business rules would ensure dimensional accuracy across MDM.

Thanks
Sutha