Make the Repository Available for Queries

Use the upload repository command to make the repository available for queries.

After you build a repository and it's consistent, you need to upload the repository using the Upload Repository Command so that all Oracle BI Server instances can access it. Uploading the repository allows the Oracle BI Server to load the repository into memory upon startup and makes the repository available for queries.

You must upload an Oracle BI repository in RPD format. You can't upload a repository composed of MDS XML documents.

When the repository is uploaded and you can connect to it, run sample queries against it to test that it's created properly. Correct any problems you find and test again, repeating this process until you're satisfied with the results.