Can we run the OTBI Analysis from Scheduled Processes?

Saahil Umratkar

Hi Folks,

Is there any way to make the OTBI Analyses available under Scheduled Processes so that it is easy for all users to run them straight from the Scheduled Processes?

Praveen Kumar Akkala-Oracle

Hi @Saahil Umratkar,

Unfortunately there is No option to run the OTBI Analysis from scheduled processes page.

You can run only the BI Publisher Reports from Scheduled Processes page.

Thanks,

Praveen

Nathan CCC

Saahil,

1) But you CAN schedule using an ESS job as a schedule process an otbi "report" that uses your OTBI "analysis" as its data source in its data model to get exactly the same data as you have in your analysis that you may also interact with on a dashboard. Same data, you just have to redo the layout.

Either by cut past the logical sql from the advanced tab of your analysis but using the standard out of the box data source source Oracle BI EE (you may need to grant permission to a role that you have use the data source in the administration settings for example grant to BI Consumer Role)

or by linking to the analysis in the catalog

Oracle® Fusion Middleware

Data Modeling Guide for Oracle Business Intelligence Publisher

12c (12.2.1.3.0) E80603-02 November 2017

Creating a Data Set Using an Oracle BI Analysis

https://docs.oracle.com/middleware/12213/bip/BIPDM/GUID-BB33AF8B-3FE3-4626-8116-2526B61A059A.htm#BIPDM189

2) and alternative you CAN schedule an OTBI analysis using an OTBI "agent" intelligence robot to deliver the analysis content on a schedule and/or based on a condition in the data rather than using an ESS scheduled process.

Oracle® Fusion Middleware

User's Guide for Oracle Business Intelligence Enterprise Edition

12.2.1.3.0

E80922-02 November 2017

Delivering Content

https://docs.oracle.com/middleware/12213/biee/BIEUG/GUID-2419AD39-ECAF-41B0-B28A-C5EABDB371CF.htm#BIEUG280

Saahil Umratkar

Hi @Praveen Kumar Akkala-Oracle , your response was helpful. Thank you so much!

Saahil Umratkar

Hi @Nathan CCC , that was a fantastic response. I appreciate your help. We'll try this approach in our project. Thanks, Saahil.