Delivers

Oracle BI delivers is used to automate the process of running the reports and sending its success/failure report automatically to the concerned people through email, text etc.
Thus, basically a dashboard user will see an alert on his analytics home page. it is similar to the notifications we get on our mobile.

To create Oracle BI delivers we need to do following:
1) Configuring scheduling tables
2) Delivery devices
3) Delivery profiles
4) Create Agent(Previously IBOT)
5) Create alerts
6) Alert section Dashboard object
7) Job Manager

Let us see each one in detail:
1) Configuring scheduling tables

• In OBIEE 11g installation, RCU(Repository Creation Utility) creates the scheduler tables. and they are by default stored in DEV_BIPLATFORM schema.
• following are scheduler tables:

1. S_NQ_JOB :- It stores the list of job to run. The columns in this table store JOB_ID, AGENT_NAME that executed the job, SCRIPT_TYPE is IBOT, USER_ID who executed the report, LAST_RUNTIME_TS,START_TIME etc.
2. S_NQ_JOB_PARAM :- It stores the parameters required to run the job. The columns in this table store JOB_ID, RELATIVE_ORDER, JOB_PARAM,DELETE FLG etc.
3. S_NQ_INSTANCE :- It stores information regarding time and date of execution of report. The columns of this table store JOB_ID, INSTANCE_ID, STATUS, BEGIN, END, EXIT_FLAG,DELETE_FLAG ,ERR_MSG_FLAG etc.
4. S_NQ_ERR_MSG:- It store the error msgs to be delivered to the end user, also the information whether the message delivered to end user or not. thus, basically this table is used for debugging. The columns of this table store JOB_ID, INSTANCE_ID, RELATIVE_ORDER, ERROR_MSG_TEXT, DELETE_FLAG etc.

2) Delivery devices

• Following devices can be configured to receive messages.
• Web browser
• Email
• Cell phone
• Wireless PDA
• Login to Analytics using Administrator credentials ---> Click on Administartor --> My account ---> Delivery options tab --> select device as Email from drop down --> click on green plus add button--> Name: OBIEEDev ,Category: Email , Device Type: HTML_Email , Address/Number: gauri.odi@gmail.com -->ok.

• Similarly, we can create a mobile device called "OBIEEMobile"

3) Delivery profiles

• It shows us the user roles like Dev, admin etc to whom the results will be delivered.
• This is how we create a delivery profile.
• Login to Analytics using Administrator credentials ---> Click on Administartor --> My account ---> Delivery options tab --> Delivery Profiles section -->click on green plus add button--> Name:"Office Profile" --> there will be list of all the devices we just created and the device priorities. we need to select these priorities, say "OBIEEDev" gets high priority in Office time 9am to 5pm and "OBIEEMobile" gets high priority after office hours. it simply means that While the user is in office,he will receive the notifications on email, when the user is at home he will receive the notifications on Mobile.--->ok.
• Similarly we can create Out of office profile in which OBIEEMobile gets high priority.

4) Create Agent

• Useful to schedule a report and generate the alert.
• Create sample report with Year,Region, Revenue and name it as Agent report.
• Now go to new--> Agent-->schedule tab --> Frequency: Once/Never/Weekly etc, Start: time and date, re-run agent every: 1 min, Until: End time and date.--> Delivery content tab--> Subject :Welcome to OBIEE Delivers , Content: Browse to the Agent report, Deliver results directly or as an attachment.-->Recepients tab--> Add administrator --->Destinations tab---> select where wuld you like to see the notifications / alerts. --> Actions tab-->Here we can specify actions to be done whenever agents completes.-->Save as "First Agent"
• Now on home page at designated, we can see an alert with a Bell symbol.
• If we click this alert, we will get list of alerts and we can choose from them and see the reports generated.

6) Alert section Dashboard object

• Open OBIEE Dashboard--> Edit--> Drag and drop Alert section --> Our alert will be shown in the dashboard once we save and run it.

 7) Job Manager

• It is web based component useful to monitor status of the agent.
• Say for example we were expecting an email to be sent to every developer on 7pm, but we did not receive it, then to debug the problem we would go to the Job manager to check what is the issue.
• Go to start--> Oracle Business Intelligence --> Job Manager --> A job manager window appears. click on File menu--> Open scheduler Information --> Give administrator password --> ok.--> In a filter view, all jobs will be displayed.--> We can go to By User section, click on Administrator and see all the agents started by administrator user along with all the details.--> we can select particular job , right click and select view job. This will display all the details about that job.

How to develop and agent based on a condition:

• Create one sample report with a condition on revenue as Revenue>3 million , save and call it "Agent report 2".
• Create another report with no measurable column, add filter on Newkey, where operator: Based on results of another analysis, browse to "Agent report 2". Save this report as "Agent report 3".
• Now create an agent : New-->Agent -->go to condition tab--> Use a condition radio button-->create--> Analysis (Browse) --> select Agent Report 2 --> True if row count is: select the row count you expect to be generated from "Agent Report 2 ".--> fill up all other information in other tabs including start and end time and save the agent.
• The agent will send an alter at designated time and we will see alert on homepage.
• Note that if the condition in "Agent report 2" evaluates to false then the report will not run and the alert will never be generated.