Oracle® Business Intelligence Server Administration Guide > Completing Setup and Managing Oracle BI Repository Files >

Importing From Another Repository

It is recommended that you create projects in the repository that contain the objects that you wish to import, and then use repository merge to bring the projects into your current repository. For more information, see Merging Oracle BI Repositories.

Use the Repository Import Wizard to import a presentation catalog (called Subject Area in Answers) and its associated children business model and physical layer objects from another repository. You can also import users, groups, variables, initialization blocks, and projects.

NOTE:  By default, the Import from repository option on the File menu is disabled. When this option is enabled, the Deprecated feature warning dialog box appears each time a user begins the import. If the user clicks yes in the dialog box, the import process continues. If the user clicks No, the import process terminates. To turn on this option, see Using the Options Dialog Box—General Tab.

Use this option when the objects you import are unrelated to objects already in the repository such as when the business model and physical layer objects do not exist. If an object of the same name and type exists, the import process overwrites the existing object with the new object. When you import objects from one repository into another, the repository from which you are importing must be consistent.

To import from another repository

  1. In the Administration Tool, open the repository in offline mode, and then choose File > Import from Repository.

    This option is only available when opening a repository offline.

  2. In the Repository Import Wizard, select a repository by its file name or, if it is being used by Oracle BI, by the ODBC DSN that points to the desired repository on that server, and then click Next.
  3. Type the Oracle BI Administrator user ID and password.
  4. In the Repository Import Wizard-Objects to Update dialog box, from the drop-down list, choose a category using Table 19 as a guide.

    Available buttons (options) depend on the category that you select. You can add only the selected object, the selected object with its child objects, or the selected object with its parent objects.

  5. Repeat Step 4 until you have added all the objects you want to import.

    If any objects need to be checked out, the Check Out Objects screen appears, notifying you that objects will be checked out.

  6. Click Next to continue.
  7. In the Finish screen, click finish.
Table 19. Categories of Repository Objects to Import


When you select a catalog, the Add with Children button become active. Presentation catalogs are always added with all their child objects. All associated objects, from the Presentation layer to the Physical layer, will be updated and synchronized.


When you select a group, the Add, Add with Children, and Add with Parents buttons become active. (You can view information about group membership from the Security Manager.)

Initialization Blocks

When you select an initialization block, the Add with Children button becomes active.

List Catalogs

When you select a list catalog, the Add with Children button becomes active.


When you select a project, all repository objects that you choose to update and synchronize appear.

Target levels

When you select a target level, the Add with Children button is active.


When you select a user, the buttons that become active depend on the user that you select in the left pane.


When you select a variable, the Add and Add with Parents buttons are active. Defined system and session variables appear in the left pane.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.