Physcal Layer

Contains Objects representing the physical data sources to which the oracle BI server submits queries
May contain multiple data sources
Created using the Analytics Administration tool
Typically the first layer built in the repository

Physical layer objects

Expand a daata source object to display the objects it contains, such as:

Connection pool

specifies connection between siebel analytics server and data source.

Schema folder

contains physical schema of tables and columns of a data source

Need to Learn in OBIEE

Building the repository layers
Testing and Validating the Repository
Dimension Hierarchies & Multiple Sources
Creating Measures
Using Variables
Authentication & Authorization
Aggregarion & Partitioning
Time Series
Denormalised Structures

BI Scheduler

How to run and configure BI Scheduler


Create the schema bi_scheduler in the database
Login as bi_scheduler and create the schema for the BI Scheduler
(Script to create the schema is located in $Oracle_BI\server\shcema\sajobs.oracle.sql)
Go to Job manager (Start>All Programs>Oracle Business Intelligence>Job Manager)
Click on File > Configuration options
navigate to the tab scheduler, sub-tab database and fill in the appropriate details to the data base
where the newly created schema is located.
navigate to the General sub-tab and type "Administrator" in the Administrator Name text box and the Administrator password in the
administrator password and Administrator password confirmation text boxes
navigate to the Mail tab, genral sub-tab and setup the e-mail with a valid server and credentials
navigate to the iBOts tab and specify the appropriate OBI presentation server
navigate to the Java extension tab and specify the appropriate Java Host Server
click OK button and exit the Job Manager

Start the Oracle BI Scheduler Service