Reviewing Multiuser Options During Development in OBIEE 11g

Reviewing Multiuser Options During Development in OBIEE 11g

After you and other developers have finished making your changes, you have several options available for analyzing the changes.

These options include the following:

• Compare with Original: Compares the working, extracted local repository to the original extracted repository • Merge Local Changes: Allows you to check in your changes. (Discussed below in "Merging Local Changes.") • Publish to Network: Locks the repository, verifies that no other developer-published changes to the master exist, and then publishes the repository. (Discussed below in "Publishing Local Changes.") • Undo Merge Local Changes: Rolls back any previously merged local changes, and leaves the repository checked out so that you can make additional changes, and then merge your local changes again. This option is only available after you have already merged local changes. • Discard Local Changes: Abandons your changes. When you select this option, the working repository closes without giving you an opportunity to save your work. You can discard your changes any time after checkout but before check-in.

Interested in mastering OBIEE? Enroll now for FREE demo on "OBIEE Training".

To review the multiuser options, perform the following steps:

1 . Using Adam's repository (abell.rpd), click File > Multiuser > Compare with Original.

2 . The "Compare repositories" dialog box appears. In this example, this dialog box compares abell.rpd (the subse repository) with originalabell.rpd. You can see the deletion of the Presentation layer tables by Adam. Scroll down and examine all objects that were deleted.

Within this dialog box, you can perform functions, such as Equalize (used to treat two objects in two repositories that have the same name but different upgrade IDs as the same object), Mark (annotates the objec you select with a surrounding box for comparison against other objects), Create Patch (generates an XML patch file that contains only the changes made to a repository, which can then be applied to the original versio of the repository to create the new version), and so on.

3 . Click Cancel. 4 . Minimize Adam's, Administration Tool. 5. Compare Helen's changes now. In Helen's Administration Tool, click File ---> Multiuser --> Compare with Original.

6 . Review the changes and then click Cancel. 7 . Helen realizes that she should not have deleted the Products table. She needs to undo her changes before the local repositories are merged, and the new master is created. Click File --> Multiuser --> Discard Local Changes.

Products is restored to the repository and the repository immediately closes (the Administration Tool remains open). 8 . Navigate to <ORACLE_INSTANCE>bifoundationOracleBIServerComponentcoreappplication_obips1repository You can clearly see that Helen's three files, original males.rpd, hmayes.rpd.Log, and hmayes.rpd, have been removed and will no longer become part of the repository update.

9 . Helen needs to continue her work in the MUDE. She therefore needs to check out the shared repository once again. In the Administration Tool, click File > Multiuser > Checkout.

Note: If you are running this tutorial on a local machine and are building both developers (abell and hmayes) repositories on the local hard drive, you may receive a Window's sharing message that prompts you to overwrite the SharedMaster.rpd. If you receive this message, click No. 10 . In the "Extract from SharedMaster.rpd" dialog box, enter the repository password and click OK. 11 . The Browse dialog box appears. Select the check box for Sample Apps Presentation and click OK. 12 . In the "Create new subset repository" dialog box, change the default file name to hmayes.rpd, as previously named, and click Save. 13 . Expand A - Sample Sales and ensure that Products has been restored. Helen's repository should look like this:

14. Minimize Helen's, Administration Tool.

For an in-depth understanding of OBIEE click on:

• OBIEE 11g Tutorials
• Checking Out a Project in OBIEE 11g
• Making Changes to the Repository in OBIEE
• Setting Up a Multiuser Development Environment in OBIEE
• Using Initialization Blocks and Variables & Create Variables