Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Is there a way to find what reports/anaylsis are set up for Bursting?

Summary
Is there a way to find what reports/anaylsis are set up for Bursting?
Content
Hello
I need to find out what reports/analysis have been created and set to burst out to employees, as we are having a change of email address, and i want to check there is no hard coding of addresses in them.
Is there an easy way to find these please?
Thanks in Advance
Regards
Helen
Comments
-
Moved to OBIEE as this question is not specific to HCM.
0 -
thanks Julian - sorry i posted in wrong place
0 -
Hi Helen,
Is this an OTBI Report or a BI Report? Could you share some Screenshot of where you are checking for me to understand better?
Thanks,
Arav
0 -
Hi Arav
The problem I have is that I know there are some reports which burst out, but as I (and current team) did nto write them, I cant locate them - so I dont know if they are BI or OTBI.
Being new to using OTBI and BI, I didnt know if there was something I could put in a search criteria to find them.
I'll keep looking in meantime and if I come across one, I will add screenshots.
Thanks
Helen
0 -
Hi Helen.
I was not able to post a reply on your post. Other people have the same issue but looks like is solved now.
You may try to find the answer for reports being used for bursting on a view called BIPUBLISHER_V within BI Platform repository schema.
That view should be on the "IAU_VIEWER" schema in the repository database.There is an attribute there called BURSTING (boolean) that may help you find the reports being used for that purpose.
This link will give you more information about the view.
https://docs.oracle.com/middleware/12212/bip/BIPAD/GUID-D68860ED-7238-4C8F-B506-CBA4AB13924E.htm#BIPAD4755
Hope this helps.
Cheers.
Fernando0 -
This may help you:
select JOB_ID,REPORT_URL,OWNER,USER_JOB_NAME,BURSTING,START_DATE,END_DATE from FUSION_BIPLATFORM.XMLP_SCHED_JOB WHERE TO_CHAR(END_DATE,'YYYY-MM-DD') > '2019-05-24' AND TO_CHAR(END_DATE,'YYYY-MM-DD') < '2021-12-01' order by end_date desc;
0