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. 

How to use Fast Formula in HCM Extract

Requirement 
Can we use Fast Formula in HCM Extrat to derive any Database calculation ?

Solution 
Oralce provides rule type attribute in HCM extract.  We can use this type to use fast formula driven attribute. 

In order to access Fast formula in Extract attributes, use type = "Extract Rule" 

If using GET_VALUE_SET method to cal value set ( only TABLE type value set are supported). Please ensure you pass value to ID field as well.