Skip Headers
Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)

Part Number E10541-07
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

10 Configuring Repositories

This chapter describes how to upload the metadata repository for Oracle Business Intelligence and to set the location of the Oracle BI Presentation Catalog.

This chapter includes the following sections:

10.1 Why Upload a Repository and Set the Catalog Location?

As the administrator, you must ensure that users can access the metadata repositories and Oracle BI Presentation Catalogs that contain the information that they require. The following list describes the importance of uploading the repository and setting the catalog location:

10.1.1 Understanding the Version Numbers Assigned to Uploaded Repository

When you upload a repository, it is copied to the local repository directory for each Oracle BI Server component, located at:

ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obisn\repository

After the repository is uploaded, it is given a version number suffix (for example, SampleApp_bi001.rpd). This version number is incremented each time that the repository is uploaded. This numbering ensures that the previous version is not overwritten. To revert to a previous version, you must re-upload the specific version of the repository to use.

Note that you can delete older versions from the repository directory or shared network directory to reclaim disk space.

10.2 Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI Presentation Catalog Location

You can use Fusion Middleware Control to upload the metadata repository and to provide an RPD publishing directory for the Oracle BI repository and a local or shared location for the Oracle BI Presentation Catalog.

Before you begin this procedure, ensure that you are familiar with the information in Section 3.2, "Using Fusion Middleware Control to Update Oracle Business Intelligence Configuration Settings."

To use Fusion Middleware Control to upload a repository and set the location of the Oracle BI Presentation Catalog:

  1. Go to the Business Intelligence Overview page, as described in Section 2.2.3, "Using Fusion Middleware Control to Manage Oracle Business Intelligence System Components."

  2. Display the Repository tab of the Deployment page.

    On the Repository tab, you can view the name of the current uploaded repository (called the Default RPD). Note that the Data Source Name (DSN) visible to Oracle BI Server clients for the repository that is uploaded through Fusion Middleware Control is always Star.

  3. Click Lock and Edit Configuration to enable changes to be made.

  4. To specify a repository publishing directory to propagate online RPD changes in a cluster, select Share Repository and provide an RPD Publishing Directory.

  5. To upload a repository and to set the location for the Oracle BI Presentation Catalog, complete the elements using the descriptions in the help topic for the page. Click the Help button on the page to access the page-level help for the following options:

    • Repository File option

    • Repository Password option

    • Catalog Location option

  6. Click Apply, then click Activate Changes.

  7. Return to the Business Intelligence Overview page and click Restart.

By default, Oracle Business Intelligence is configured with a sample default repository called SampleAppLite.rpd. See Section 1.5, "Working with the Sample Application" for more information.

See Appendix A, "NQSConfig.INI File Configuration Settings" for information about advanced configuring settings for repositories. Note that hosting multiple repositories on a single Oracle BI Server is not recommended for production systems.

For information about using methods in the Oracle BI Systems Management API to change configuration settings, see Chapter 23, "Introducing the Oracle BI Systems Management API."

10.3 Using the System MBeans to Upload the Metadata Repository

The recommended approach for uploading the metadata repository is to use the Repository tab of the Deployment page, as described in Section 10.2, "Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI Presentation Catalog Location." You might encounter specific situations in which you must upload the repository using a different approach. For example, the size of the repository file can be too large for Fusion Middleware Control to handle, or you might be working in a development environment and have unique needs.

In such exception cases, you can use the System MBeans to manage repositories programmatically or from scripts, as described in Chapter 23, "Introducing the Oracle BI Systems Management API." You can also use the Fusion Middleware Control System MBean Browser to upload the default metadata repository, as described in the following procedure.

To use the System MBean Browser to upload the metadata repository:

  1. Manually copy the repository file to upload to the local repository directory for each Oracle BI Server component in the deployment, at:

    ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obisn\repository

  2. If the name or password of the repository has changed, then complete the following steps:

    1. Use the System MBean Browser to specify the new name for the repository. See Section 3.5, "Using the Fusion Middleware Control MBean Browser to Update Configuration Settings" for more information.

    2. Commit your changes.

    3. You must change the password for the repository file in the oracle.bi.enterprise credential map. Otherwise you cannot restart the BI Server, which requires this password to decrypt the file.

      In Fusion Middleware Control, navigate to the bifoundation_domain node and from the menu, select Security, then select Credentials.

    4. Drill the oracle.bi.enterprise map, select the appropriate repository, and click Create Key to display the Create Key dialog in which you create a new credential.

    5. Create the key for the repository by completing the fields as follows:

      • Key = Set the key for the repository to repository.name, where name is the name of the repository, without the .rpd suffix.

      • User Name = Set the value to any name.

      • Password = Enter the password for the repository file, then retype it in the Confirm Password field.

    6. Click OK.

  3. Restart Oracle Business Intelligence.

Note that if you perform this procedure and then later scale out the deployment to include additional Oracle BI Server components, then you must manually copy the repository file to the local repository directory for the new Oracle BI Server component. Perform this copy step after the Oracle BI Server component has been created, but before restarting the system.