Shortcut to run BIP report in Fusion (Sandbox)

 Requirement 
How to access Oracle BIP Report from fusion without accessing Tools >  Reports and Analytics and ESS job. 

Solution
We can use sandbox to setup a shorcut in required screen in Oracle fusion. 

Create a sandbox using Structure option.

 

 

Select create page entry option. 

Select the group name where you want to keep this shortcut. 

EL expression can be used to control access for specifc user or role 

Select Link type = Dynamic URL and provide the report path and name ( as shown) in destination for web application. 

Save and publish the sandbox. 

Go to path and a shortcut will be shown on selected group. 

Different methods to access BIP Report in Oracle Fusion

Requirement 
What are different ways one can access BIP Reports 

Solution 
Reports can be accessed via - 

1) Reports and Analytics - Go to report path and run or schedule report 

2) Oracle Fusion Scheduled Process - Setup and ESS job for BIP report and access report data by running ESS job from Oracle fusion. 

3) Oracle Fusion (any screen) -  We can use sandbox to create new page entry and link this with report path. A BIP report can be linked using Static and Dynamic options. 

Static - This will be not instance dependent and report URL will be full link including instance details. 
Dynamic -  Suggested to use as this need only report path and name. Instance name will be automatically added based on used instance. 

Working with Bursting in Oracle Fusion

Requirement 
How to define delivery details for an BIP report at run time ? 

Solution
Similar to e-Business BIP reports are delivered to use bursting concept for run time delivery selection. 

Bursting SQL need to be defined at Data Model. 

Following are the options to run data model and bursting scope - 

• Data Model - Data model can be executed directly from data model by using view button.
  Bursting does not execute in this.
  
  
• Report (Online View) - Report can be run using Open option in Oracle analytics. Bursting  defined at associated Data model does not execute in this. 
  
  
• Report submitted as Job - Report can be run using (More > Schedule) option in Oracle analytics. Bursting  defined at associated Data model may/may not execute in this. In order to execute Report ned to be updated by selecting properties option and enable bursting need to be checked if bursting is defined at linked data model. 

 

• ESS Job - If ESS job is setup in Oracle fusion and linked with BIP report. Any bursting defined at associated data model will be executed when report run using ESS job.