OBIEE11g Scheduling Mechanism

Report or Dashboard scheduling functionality is available in OBIEE11g. Scheduling mechanism is more or less similar as in OBIEE10g; but the configuration in 11g is slightly different.

In OBIEE10g the table creation script is provided by Oracle and you need to execute it before configuring the IBOT scheduler. Whereas in OBIEE11g all the tables are preconfigured.

During Repository Creation Utility (RCU) in 11g, two schema called Metadata schema (MDS) and BIPLATFORM needs to be created. All the scheduler related tables (e.g. S_NQ_JOB, S_NQ_JOB_PARAM etc.) will automatically create into BIPLATFORM schema.

Steps below to configuration the Mail Settings in OBIEE11g:

Step1) Login to Fusion Middleware Control Enterprise Manager using the weblogic admin credentials

Step2) Click on Business Intelligence on the left pane and then coreapplication

Step3) Click on Mail tab available under Deployment tab to configure the email settings

Step4) Lock and Edit Configuration and enter the following details:

a. SMTP server name of your email
b. SMTP server port number
c. Display name of sender – It can be any name (e.g.Oracle Business Intelligence)
d. Email address of sender – Sender’s email address (e.g. obiee11gscheduler@abc.com)
e. Enter the Username – Same as the email sender’s (e.g. obiee11gscheduler@abc.com)
f. Enter the Password
g. Confirm password
h. Number of retries upon failure
i. Mention Maximum recipients
j. Select the appropriate Addressing method radio button as per your requirement

Step5) Once done click on Apply button and then Activate the changes

Step6) Restart the services to reflect the changes

Step7) Now create a report/analysis after connecting to OBIEE11g web portal and save the analysis

Step8) Create a new Agent. On the General tab set the priority

 

Step9) Move into Schedule tab, Enable it and schedule the agent

Step10) Specify the Condition if any

Step11) Browse the analysis created it Step7 and set the report delivery format

 

Step12) Add the recipients in the next tab and select the destinations

Step13) Save the Agent and run it; it will deliver the attachment (CSV format) to the recipients added in Step12.