Create a BIP bursting report queue?

1468930

Hi guys,

At one of my cliënts we have a set of BIP burst-reports being run daily, however when the data hasn't loaded correctly they need to start all 30+ bip reports by hand.

Is there a way to script this, so we can just start an agent or something and that all bip reports will be bursted in a queue?

We are working on OBIEE 11G 11.1.1.7.160119 (Build 151223.0054 64-bit).

Thanks in advance guys!

Gr. Martijn

Rajesh Dhanapal

Hi Martijn,

Did you try the retry limit with pause time?

Best regards,

Rajesh Dhanapal.

1468930

Hi Rajesh,

Where  can i define the trigger, it's empty:

Thomas Dodds

You create the schedule trigger in the data model of the BIP report you want to burst... or you have a separate model that has the trigger in it.  No triggers in the drop down means your selected model doesn't have one built.

Robert Angel

So the idea is that you use something like trunc(sysdate) < max(last_update_date) or similar logic as a high water mark.

Thomas Dodds

I've seen some clients with the scheduling data model with a host of triggers for various reasons; I've also seen the schedule trigger built in the report by report models ... I'd go former if you are doing a lot of scheduled/bursted reports.  Manage it as simply as you can.

Robert Angel

Agreed, I was addressing his one off tactical issue, not the bigger strategic one, I have implemented exactly what you describe in the past - sometimes via Apex - which provides a simple but effective container to control and log exactly what is being run when...