Creating RPD and Importing Metadata

Creating RPD

Oracle Business Intelligence RPD is a file with the extension “.rpd,” which contains data definitions and business rules known as “metadata”. This RPD is managed through BI Administration tool.

**In order  to have a clear picture we are  just importing only metadata i.e The skeletal Framework of the tables into our BI Admin tool.

Creating RPD file and importing metadata from a database.

• Goto start >All Programs>Oracle Business Intelligence>BI Administration  which opens a  window Oracle BI Admin tool
• In Oracle BI Administration tool goto File Menu àNew Repository

This Opens below Tab

·         Provide your Desired Name: like Practice001

·         Location : RPD files will always be saved in default location

           C:\BI11g\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository 

**It is a best practice to save all the RPD files in Default Location.
**minimum length of password is 8 Characters.This Should include UPPER CASE, lower case and numericals.

·         Repository Password:  Your desired password.

         

        Click on next which follows the below Screen

       Fill all the required fields

·         Connection Type              :               OCI 10g/11g (For Native Oracle Databases)

·         Data Source Name           :               orcl

·         User Name                        :               supplier2

·         Password                          :               Admin123(or whatever the password you have                                                                                  provided while loading supplier2.dmp)

•        Click on next which follows the below tab

• Uncheck keys and foreign keys. 

• In the next screen we can see list of schemas that are available in our database Under  data Source View. Under that expand Supplier2   as shown below image.

• Expand SUPPLIER2  and select the following tables(Use Ctrl+Click to select the following  tables)

• D1_ORDERS2, D1_CUSTOMER2, D1_CALENDER2, D1_PRODUCTS

• 

• Click on import Selected Button (>)

• A  connection pool tab will open where you can rename the connection pool to your desired name like OracleCP.

• Avoid Providing spaces in connection pool names as it create problems in  future.

 

Connection Pool

Connection Pool is defines as the connection between database and Oracle BI Server. It is a interface where database credentials are provided in RPD.

• When import is complete, expand SUPPLIER2 in the Repository View and verify that the four tables loaded are visible.
• C lick on Finish. This opens the repository.
  

Isolation Level

• Isolation Level controls the transaction locking behavior for all statements issued by a connection.

Comitted read

Specifies that shared locks are held while the data is read to avoid dirty reads. However, the data can be changed before the end of the transaction, resulting in non-repeatable reads or phantom data.

Dirty Read

• This is the least restrictive isolation level. When this option is set, it is possible to read uncommitted or dirty data, change values in the data, and have rows appear or disappear in the data set before the end of the transaction.
  
• Dirty data is data that needs to be cleaned before being queried to obtain correct results (for example, duplicate records, records with inconsistent naming conventions, or records with incompatible data types).

Repeatable Read

• Places locks on all data that is used in a query, preventing other users from updating the data. However, new phantom rows can be inserted into the data set by another user and are included in later reads in the current transaction.

Serialization

Places locks on all data that is used in a query, preventing other users from updating the data. However, new phantom rows can be inserted into the data set by another user and are included in later reads in the current transaction.