Use the upload repository command to make the repository available for queries.
After you build a repository and it is 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.
When the repository is uploaded and you can connect to it, run sample queries against it to test that it is created properly. Correct any problems you find and test again, repeating this process until you are satisfied with the results.
Note:
You must upload an Oracle BI repository in RPD format. You cannot upload a repository composed of MDS XML documents.