Online and Offline Repository Modes
You can open a repository for editing in either online or offline mode. You can perform different tasks based on the mode in which you opened the repository.
Opening a Repository in Offline Mode
Use offline mode to view and modify a repository while it is not loaded into the Oracle BI Server. If you attempt to open a repository in offline mode while it is loaded into the Oracle BI Server, the repository opens in read-only mode.
Only one Administration Tool session at a time can edit a repository in offline mode.
To open a repository in offline mode
1 In the Administration Tool, select File > Open > Offline.
2 Navigate to the repository you want to open, and then select Open.
3 In the Open Offline dialog box, type a valid user ID and password, and then click OK.
This opens the repository for editing.
NOTE: If the server is running and the repository you are trying to open is loaded, the repository will only open in read-only mode. If you want to edit the repository while it is loaded, you have to open it in online mode. Also, if you open a repository in offline mode and then start the server, the repository will be available to users; any changes you make will become available only when the server is restarted.
Opening a Repository in Online Mode
Use online mode to view and modify a repository while it is loaded into the Oracle BI Server. The Oracle BI Server must be running to open a repository in online mode. There are certain things you can do in online mode that you cannot do in offline mode. In online mode, you can perform the following tasks:
■ Manage scheduled jobs
■ Manage user sessions
■ Manage the query cache
■ Manage clustered servers
■ Stop the Oracle BI Server
To open a repository in online mode
1 In the Administration Tool, select File > Open > Online.
The Open Online Repository dialog box appears, from which you select a data source.
The data sources displayed in the dialog box are all the User and System DSNs on your computer that are configured using the Oracle BI ODBC driver.
2 Select a data source, type a valid user ID and password, and then click OK.
The repository opens that contains the business model corresponding to the data source
NOTE: If you expect to work extensively with the repository (for example, you plan to check out many objects), select the Load all objects option. This loads all objects immediately, rather than as selected. The initial connect time may increase slightly, but opening items in the tree and checking out items will be faster.