Use Source Control Management in Day to Day Repository Development

Update, Save, and Check In Changes for Repositories Under Source Control

After your MDS XML repository is set up under source control, follow these steps to update, save, and check in changes to your repository.

Ensure that you've a local copy of your working MDS XML repository files that are under source control by issuing the appropriate commands in your SCM system. For example, for Subversion, you can issue the command svn info as shown in the following example text:

C:\myProj\repos>svn info
Path: .
Working Copy Root Path: C:\myProj\repos
URL: file:///C:/SVN/myProj/trunk/sample1
Repository Root: file:///C:/SVN/myProj
Repository UUID: 6b995c92-3ec0-fa4b-9d58-c98e54f41792
Revision: 3
Node Kind: directory
Schedule: normal
Last Changed Author: joe_user
Last Changed Rev: 2
Last Changed Date: 2011-11-19 15:20:42 -0600 (Sat, 19 Nov 2011)

In the Administration Tool , from the File menu, select Open, then select MDS XML.
Open the file in offline mode.
Select the root folder location for your MDS XML files and click OK.
If this is the first time you've opened this MDS XML repository in the Administration Tool, you're prompted to specify whether this repository is a standalone MDS XML repository, or whether it's under source control. Select Use Source Control and click OK.

This choice is saved for this repository. To view the status of this repository at any time, select Tools, then select Options, then select the Source Control tab.
After you make changes to your repository, select File, then select Save, or click Save on the toolbar. The Administration Tool displays a list of changes.
Click Yes to run the commands in the SCM system.

After accepting the changes, you can't cancel. Canceling the changes creates an inconsistent repository. You must continue the SCM commands process.

When the Administration Tool issues the SCM commands, the commands rearranged into the most optimal order.
Check in the changes directly in your SCM system.

Handle Errors

Learn how to handle errors in the SCM system.

Sometimes errors, such as an expired label or network problem, occur when the Administration Tool delivers changes to the SCM system.

Saving to a binary Oracle BI repository file is the simplest option for transient problems like network errors, where you just need to try again later. Saving as MDS XML is required when some sort of work is required to fix the problem, such as merging conflicting changes.

In the Administration Tool, select File, then select Save As to save the repository to a temporary location in Oracle BI repository file format or MDS XML format. Close the Administration Tool.
Take action to resolve the issue. For example, refresh an expired label or test and view a failed network connection.

In the case of an expired label, you also need to merge the contents of the refreshed label with the temporary saved MDS XML repository. Use a third-party merge tool to do this.

For detailed information about the MDS XML representation of repository objects so that you can successfully make merge decisions, see XML Schema Reference for Oracle Business Intelligence Enterprise Edition.
Open the saved repository in the Administration Tool.
Select File, then select Source Control, then select Link to Source Control.
Click Save to save changes from the saved repository into the MDS XML files under source control.

Steps 4 and 5 of this procedure cause the Administration Tool to keep memory objects loaded from the saved Oracle BI repository file or MDS XML files, but to then consider them to belong to the source control MDS XML repository instead. When you click Save, the Administration Tool saves the memory objects to the source control repository.

Test Repositories Under Source Control

During the course of repository development, you need to perform testing in online mode to validate your repository.

You can only load an Oracle BI repository in RPD format into the Oracle BI Server to make it available for queries. Because of this, you must save your development MDS XML repository in Oracle BI repository format from time to time when you want to perform online testing.

See Make the Repository Available for Queries.

In the Administration Tool, open your MDS XML repository in offline mode, select Save As, then select Repository to make the repository available for queries.

View the Source Control Log

The Source Control Log window shows the commands that the Administration Tool issues to your SCM system.

It also shows any post-save text you specified in the Post-save comment tab of the SCM Configuration Editor.

By default, the Source Control Log window appears when SCM commands are being run. Alternatively, you can select File, then select Source Control, then select View Logs to see the Source Control Log window.

You can choose the following options for this dialog:

Close when commands finish: Causes the log window to close automatically when commands are complete, unless errors occur.
Only show dialog when errors occur: Hides the window during SCM command processing unless errors occur. By default, the Source Control Log appears automatically when SCM commands are being run unless this option is selected.

The text displayed in the Source Control Log is persistent until you close the repository. This means that all SCM command output is available for view, regardless of whether the dialog is open during individual operations. While SCM commands are being run, the Close button is disabled until the SCM commands have finished or have stopped with an error, unless Only show dialog when errors occur has been selected.

The Source Control Log does have a 32K character limit. When the window buffer becomes full, then the oldest commands are removed from the Source Control Log display to make room for the latest command output. To see the full output, go to the Administration Tool log at:

ORACLE_INSTANCE/diagnostics/logs/OracleBIServerComponent/coreapplication_obisn/user_name_NQSAdminTool.log