Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Is there a way to find what reports/anaylsis are set up for Bursting?

91
Views
6
Comments
Helen Thomas-53877
Helen Thomas-53877 Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

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

Tagged:

Comments

  • Julian Challenger-Oracle
    Julian Challenger-Oracle Rank 6 - Analytics Lead

    Moved to OBIEE as this question is not specific to HCM.

  • Helen Thomas-53877
    Helen Thomas-53877 Rank 2 - Community Beginner

    thanks Julian - sorry i posted in wrong place

  • Aravind Ragul-4349
    Aravind Ragul-4349 Rank 2 - Community Beginner

    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

  • Helen Thomas-53877
    Helen Thomas-53877 Rank 2 - Community Beginner

    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

  • FPonte
    FPonte Rank 6 - Analytics Lead

    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.

    Fernando

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    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;