Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Create a BIP bursting report queue?
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
Answers
-
Hi Martijn,
Did you try the retry limit with pause time?
Best regards,
Rajesh Dhanapal.
0 -
Hi Rajesh,
Where can i define the trigger, it's empty:
0 -
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.
0 -
So the idea is that you use something like trunc(sysdate) < max(last_update_date) or similar logic as a high water mark.
0 -
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.
0 -
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...
0