How to import tables to create the new repository using BI Administration tool

1)      To open BI Admin tool click on Start -> All Programs ->Expand  Oracle Business Intelligence -> Select BI Administration

           

 

2)      It opens BI Administration Tool as shown in Fig.

3)      Now go to File ->click on  New Repository

 

4)      In Create New Repository wizard  provide  appropriate  Repository  Name ,Location  &  Password  & click Next :

5)      In Select Data source  step select Connection Type  from Drop down list & Provide Information i.e. Data source Name , User name & Password  & click Next :

6)      In select Metadata Types select the metadata type you want to import :

7)      In Select Meta data Objects Step expand your schema to import the tables you want 

 

8)      To import required tables in Physical layer select tables & click on    to remove the tables click on  .

9)   Now expand the Data source to confirm that all tables are successfully imported.

10)      Now Click on Finish. you can see that all tables are imported successfully in Physical layer