Repository(RPD) Questions & Answers

01. What is the path of repository in OBIEE 11g?

Answer:- Following is the path of repository in OBIEE 11g. All RPD file by default stores on this path.

OBIEE_HOME/instance/instance1/bifoundation/oracleBIApplication/coreapplication_obis1/repository

02. How to execute procedure from repository?

Answer:- Follow the following procedure to execute procedure from repository

1. Open Connection Pool.

2. Go to Connection Scripts.

3. Drill down execute events such as

i) Execute on Connect.

ii) Execute before query.

iii)Execute after query.

iv)Execute on disconnect.

4. Now press New button on any execute event. It will open physical SQL.

5. You can call procedure by writing following code in physical query.

EXEC <procedure_name>(parameters)

Example :- EXEC PROC_LOAD(25)

03. How to refresh the changes in repository, if any changes happened in a table/database?

Answer:- We need to manually refresh the repository, in case of any changes in table/database.

In case of addition, such as create new column in existing table, then we need to import metadata of updated table to the repository.

04. What is Online/Offline mode in OBIEE?

Answer:- There are two mode in OBIEE to save your changes to repository

i. Online Mode

ii.Offline Mode

i) Online Mode :- If we want to reflect the changes in the Repository to Presentation Services immediately without restarting the services.

Reload Server Metadata will Reflect the changes.

ii) Offline Mode :- In this mode, the changes are going to save in repository in the form of metadata.