Tuesday, July 6, 2010

Oracle BI EE- Multi User Development (MUD)

 

MUD stands for Multi-User Development(MUD) for repositories. Typically when you have many data sources and lots of tables, it would make sense to distribute the repository development work to multiple users. MUD is basically a feature of the BI EE admin tool wherein multiple users can work on the repository at the same time and not worry about change control.

The below diagram shows how the MUD works.

clip_image002

Following are the pre-requisites for enabling MUD in an environment.

1. All the client machines should have the admin tool installed.

2. A shared drive to host the Master Repository

3. The client machines should have access to the master repository

For the MUD to work, the repository that is worked upon by all the users should be kept in a shared directory. This shared directory should be accessible to all the users. In each of the client’s Admin tool, enter the Shared Directory path.

The concept of MUD is based on Projects. Projects are basically subsets of objects within the Admin tool that can be assigned to individual users. From within the Admin tool once can navigate to Manage – Projects. Following are the steps involved in a MUD env –

1. Create Projects with subset of objects to be assigned

2. Assign the individual projects to different users

3. Users Checkout Individual Projects they have access to

4. Once done, Users merge the changes back to the local master repository.

5. Choose “Publish to Network” to copy the modified and merged local master repository to the shared drive.