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.
- In the Administration Tool, select File > Open > Offline.
- Navigate to the repository you want to open, and then select Open.
- In the Open Offline dialog box, type a valid user ID and password, and then click OK. 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
- In the Administration Tool, select File > Open > Online.
- Select a data source, type a valid user ID and password, and then click OK. 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.
Checking In Changes
When you are working in a repository open in online mode, you will be prompted to perform a consistency check before checking in the changes you make to a repository.
If you have made changes to a repository and then attempt to close the repository without first checking in your changes, a dialog box opens automatically asking you to select an action to take. If you move an object from beneath its parent and then attempt to delete the parent, you will be prompted to check in changes before the delete is allowed to proceed.
- Make changes available immediately for use by other applications. Applications that query the Oracle BI Server after you have checked in the changes will recognize them immediately. Applications that are currently querying the server will recognize the changes the next time they access any items that have changed.
- Specify that repository changes should be written to disk immediately. If the Oracle BI Server is shut down abnormally, using the Check Changes dialog box will make sure that checked-in changes to the repository can be recovered. Changes that are checked in but not saved to disk will be restored through the server's error recovery processing. (This processing takes place automatically whenever the Oracle BI Server has been shut down abnormally.)
Posts
