(Q1) What is BI Publisher?
Ans: It is a reporting tool for generating the reports. More than tool it is an engine that can be integrated with systems supporting the business.
(Q2) What are the Reporting tools available in the Oracle Fusion?
Ans: 1. BIP Reports
2. OTBI reports
3. Smart View Reports
4. Financial Reporting Studio
(Q3) What is the required installation for using BI Pub report?
Ans: BI Publisher desktop tool has to be installed. Using this tool you can preview or test the report before deploying the same on to the instance.
(Q4) What is a data template?
Ans: Data template is an xml structure which contains the queries to be run against the database so that desired output in xml format is generated, this generated xml output is then applied on to the layout template for the final output
(Q5) What Triggers Are Supported In Data Template?
Ans: Before report and after report are supported.
(Q6) What are the various components required for developing a BI publisher report?
Ans: 1. Data Template
2. Layout template
3. Integration with Oracle Concurrent Manager
(Q7) What are the output formats supported by layout template?
Ans: xls, html, pdf, eText etc are supported based on the business need.
(Q8) What is XML Publisher?
Ans: Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. It provides a new approach to report design and publishing by integrating familiar desktop word processing tools with existing E-Business Suite data reporting. At runtime, XML Publisher merges the custom templates with the concurrent request data extracts to generate output in PDF, HTML, RTF, EXCEL (HTML), or even TEXT for use with EFT and EDI transmissions.
(Q9) What is the difference between XML publisher and BI Publisher?
Ans: XML Pub operates entirely within EBS and can only be used within EBS. BIP can be installed as a standalone version running off of several OC4J compliant engines, such as Application Server and Tomcat. BIP can be pointed anywhere, so you could do reports out of an OLTP or warehouse database, MSSQL and even within EBS. Licensing is already included in EBS, and the standalone costs whatever plus maintenance.
(Q10) What is a layout template?
Ans: Layout template defines how the user views the output, basically it can be developed using Microsoft word document in rft (rich text format) or Adobe pdf format. The data output in xml format (from Data template) will be loaded in layout template at run time and the required final output file is generated.
(Q11) What are the navigation to build BIP report in Oracle Fusion?
Ans: In Oracle Fusion, navigate to Build the BIP Report.
- Navigation of the Data Model: Tools > Report and Analytics > Browse Catalogue > New > Data Model
- Navigation of Data Templates: Tools > Report and Analytics > Browse Catalogue > New > Report
(Q12) What exactly is a data model?
Ans: Data Model is a BI Publisher object that includes a set of instructions for retrieving and structuring data for reports. The report’s data model specifies the report’s data source, data structure, and parameters.
(Q13) What are the Data Model Components?
Ans: Data Model Components are
- Data Set
- Event Triggers
- List of value
(Q14) What exactly is a data set?
Ans: The logic in a Data Set is used to retrieve data from a single data source. A data set should retrieve data from a variety of sources, including a database, an existing data file, and a web service call, among others.
(Q15) Is it possible to use Triggers in a BIP Report?
Ans: Yes, Event Triggers can be used in BIP reports. Before and after data triggers, as well as scheduling triggers, are all supported by the Data Model.
A call to execute a set of functions specified in a PL/SQL package stored in an Oracle database is used in the Before Data and After Data triggers. For scheduled reporting, the Schedule Trigger is used.
(Q16) What are the terms “split by” and “deliver by”?
Ans: Split by – Select how you want the data to be split.
Deliver by – Choose who you’d like the data to be delivered.
(Q17) What is the best way to schedule BIP reports?
Ans: Following options are available to schedule BIP Reports
- Select Report and Analytics > New > Report Job
- Go to the Create section > Published Reporting > Report Job.
- Select Catalog > Select Report > More > Schedule
- You can also use ESS Job to schedule the report.
(Q18) How you can make a report in different languages in BIP?
Ans: We will use the translation feature to make the report available in different languages. Templates can be translated from the properties page, and XLIFF files for a single template can be generated from the properties page. To create the XLIFF files, click extract translation.