Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Multi User Development of Repositories (MUD)

Posted by Venkatakrishnan J on March 27, 2008

I had some time today to put together a simple document for enabling 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. The concept of Repository Merging was actually introduced in order to facilitate MUD. Lets try to understand the concept of MUD today.

Lets start with the simple diagram below.

      

The above diagram illustrates how the MUD works. In order for the MUD to work following are the pre-requisites

1.   A shared drive to host the Master Repository
2.   All the client machines should have access to the master repository.
3.   All the client machines should have the admin tool installed.

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.

      

Now, open the Master repository in offline mode. The entire concept of MUD revolves around objects called as Projects. So, from within the Admin tool navigate to Manage – Projects.

      

This will open up a project window. Projects are basically subsets of objects within the Admin tool that can be assigned to individual users. So, the idea is to assign different projects to different users. Also, each of these projects can contain one or more Logical Fact tables. As soon as a logical fact table is included all the other dependent objects would automatically be part of the project. Typically when we start with a repository, we would not be having any BM or presentation layers. So, it is recommended that one imports all the physical tables and creates the physical joins in the repository first before implementing MUD. After that we can create dummy BM and presentation layers so that they can be assigned to individual projects. Also, one can assign Users, Init Blocks and Variables to a project.

      

After creating and assigning objects to a project, the next step is to save the master repository in a shared drive. Now, open up a client Admin tool and navigate to File – Multiuser – Checkout. This Check out process does 2 things

1.   Copies the Master repository from the shared drive to the local drive ( This will serve as the local master repository).
2.   Gives you a screen to choose the project that you have the authority to work on.
3.   Creates a subset repository (would ask you to enter the name) which would contain only the selected project related data.

So, basically the idea is to work on the subset repository (like creating/deleting dimensions, hierarchies etc) and then merge the changes back to the local master repository. The merge process will lock the master repository in the shared drive. In order to release the lock one would have to Choose “Publish to Network” which will copy the modified and merged local master repository to the shared drive. The process would be the same for all the other users.

About these ads

12 Responses to “Oracle BI EE 10.1.3.3/2 – Multi User Development of Repositories (MUD)”

  1. [...] Whilst I remember it, Venkat has written up another excellent OBIEE article, this time on performing multi-user development against an OBIEE repository. [...]

  2. Sunil Epari said

    Excellent Post Venkat and like other postings this will be very helpful for a lot of people.

    I do have one question. As I understand most of the implementation/deployment are on Linux/Unix kind of environment. Having a shared drive/folder is not a common practice in these environment. Is there something you are aware of that will help deploy a MUD in a non windows based environment, excluding the fact that we can share a folder on these environment by using a third party software like SAMBA

    Appreciate your comments.

    Thanks
    Sunil

  3. Desconhecido Oliveira said

    i have a question! can you help-me ,please?

    i follow this steps, but i can’t see the changes in online mode.

    i am using the BIEE in Fusion intelligence, so i use the project already created in ebsAnalyticMaster.rpd

    First i copy the RPD from the master repository into a shared folder.

    after i use the rpd in multiuser mode, but when i publish to network the new changes i can’t see this changes in master repository.

  4. Venkatakrishnan J said

    @Sunil – Since the BI EE Admin tool is available only for Windows, its better that you put the repository in a windows shared drive that every user can access. Once the MUD is complete just copy the repository over to the Linux environment.

    @Desconhecido – Do you have write access on the shared drive? Also, did you try opening the new master repository?

  5. Desconhecido Oliveira said

    Hi!
    yes i have full access in this directory!

    I have a main question!
    I have 2 directories, one is the directory of master repository where is the RPD used in analytics and i have other directory where i have the RPD to work in MUD.

    the question is: How the Administration tools copy the news changes made in shared folder into master respository folder? is that automatic after i publish it to network?

    tks for the help

  6. Amit Bhatnagar said

    Or you can connect to your main RPD (Linux/Uni) in online mode, while still working in MUD….

  7. Aabid Abbasi said

    Venkat,

    I have one quick question.

    After i merge the local subset RPD to the local master RPD. It exposes the entire repository for the local developer to make further changes before he/she publishes it. Is there a way to make this local RPD (after merge) read only so that nothing else can be changed by the local developer in addition to the changes already made before he/she publishes it?

    Thanks

    Aabid

  8. Mano said

    How do I connect to an RPD on a Linux box in Online mode? Should I modify my AnalyticsWeb ODBC?

    Thanks

  9. Lorne said

    Hi there,

    I have two questions:

    1: How do I publish the changes made to the master repository in the project shared drive, to be available in OBI Answers. Do I have to copy the shared Directory Master file into the OracleBI/Server/Repository folder and re-start the server? (question has been asked a couple of times before, but I can never find a answer to it.)

    2: How do we test/view the changes made in the MUD environment. If changes are made to the .rpd file in online mode, we can do a check in and move to Answer and be able to see the outcome of those changes. Where in the MUD, we make the changes and then merge the local content, publish the files, and then do we have to wait till the .rpd file is copied to the OracleBI/Server/Repository folder and the BI Server restarted before we see the changes?

    Thanks
    Lorne

  10. GV said

    Excellent piece of work!

    For the multiuser development it looks like the projects basically comprise fact tables and associated dimensions. My questions:
    1. If the project consists of lets say a logical star schema what happens to conformed dimensions.
    2. I have 2 subject areas in my BMM layer, can I create projects defining users and the one subject area that they have access to. In that case can I create one report accessing both subject areas in OBI answers.

    Thanks for inputs.

  11. John said

    Venkatakrishnan

    You wrote:
    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.

    My Question:
    Will MUD work with a shared network drive that is created using Samba in an AIX environment?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 151 other followers

%d bloggers like this: