Did you like the topical Star Wars reference? Have you seen the new film yet? Of course not, you've got bursting to do.
In my previous post Bursting Using OBIEE Agents Part One we looked at how our dashboard was filtered by region using a session variable and we saw how an OBIEE agent can run the dashboard and save it to the file system. The format I chose was .PDF but there are other formats you can choose.
An analysis can be exported in all the above formats but a dashboard page is restricted to PDF, Excel and HTML.
In this post we shall:
So, to recap here is my dashboard:
Notice the regions in our prompt....I want to burst my report out across my regions.
We shall now create a new analysis which will list out the regions to drive the bursting.
I don't care about the formatting, I just want my analysis to list the regions:
These are the droids regions we're looking for. Just filter your analysis to match your desired burst output.
We shall now create an agent which will export the region definition to a text file. The bursting agent has exactly the same configuration as the dashboard agent we created in the previous post with the following exceptions:
Here we define the file format of the exported bursting definition (plain text):
Run the agent and check that it is exporting our bursting definition to our Agent_Temp folder:
and review the contents:
Yep, those are the regions I want to burst out.
Saschinvoke is the Oracle BI Scheduler command line job invocation tool. On Windows it is called saschinvoke.exe and on *NIX it is saschinvoke. It enables you to schedule a job via the command line. It is typically used to launch jobs outside of the OBIEE scheduler using a 3rd party scheduler or batch routine. Saschinvoke isn't anything new and it's been covered in other blogs but it is key to our process so I'll explain how it works.
We shall use sachinvoke to launch our agent via a command script.
The utility can be found in OBIEE_HOME\bi\bifoundation\server\bin
so in my case it is located in: E:\Oracle\OBIEE\Oracle_Home\bi\bifoundation\server\bin.
Here is a link to the command in the Oracle Documentation.
The syntax for the command is:
SASchInvoke -u (-j | -i ) [-m [:]] [(-r | -a )]
We will only need the following parameters to launch our agent:
-u: User name
-i: iBot path (the path to our agent)
The syntax is as follows:
saschinvoke -u bi_admin -i "/shared/Blog/Agent Burst/Region_Burst_Agent" -m SERVERNAME:9511
You will be prompted for the password for your BI administrator user:
I've highlighted the machine:port parameter because this isn't needed in 11g. Oracle haven't taken into account the change in port numbers in 12c and the saschinvoke utility will fail without the machine:port reference because it still defaults to the old 9705 port.