Q) Navigation to build the BIP Report in Oracle Fusion.
->
Navigation to Build the BIP Report in Oracle Fusion.
Data Model Navigation.
Tools -> Report and Analytics -> New -> Data Model
Data Template Navigation.
Tools -> Report and Analytics -> New -> Report.
Q) What is Data model?
-> Data Model is a object which contains set of instructions for BI Publisher to retrieve data and structure data for report. Data Model defines data source, data structure and parameter for the report.
Q) What are the Components of Data Model?
-> Components of Data Model.
1. Data Set
2. Event Triggers
3. Flexfields
4. List of value
5. Parameters
6. Bursting.
Q) What is Data Set?
-> Data Set contains logic to retrieve the data from the single data source. A data set can retrieve the data from variety of data sources like database, existing data file, web service call etc.
Q) Can we use Triggers in BIP Report?
-> Yes, we can use Event Triggers in BIP report. The Data Model supports before data and after data triggers as well as schedule triggers.
Before Data and After Data triggers consists of a call to execute a set of functions defined in PL/SQL package stored in oracle database.
Schedule Trigger is executed for a scheduled reports.
Q) What is split by and deliver by?
-> Split by - Choose how you want to split the data.
Deliver by - Choose to whom you want to deliver the data.
Q) How to generate multiple language report in BIP ?
-> We can use translation feature to generate the report in multiple language repot. Template can be translated from the properties page from the properties you can generate XLIFF files for the single template. Click extract translation to generate the XLIFF files.
Q) How to schedule the BIP reports?
->
1) In report and analytics -> New -> Report Job
2) In Create Section -> Published Reporting -> Report Job
3) In Catalog -> Select Report -> More-> Schedule4) You can schedule the report using ESS Job also.
For more Oracle Fusion HDL Videos please click here
For more Oracle Fusion Extract PDF Output Videos please click here
