Over View on Oracle BI College editor
BI Publisher separates extracting data from the database from the mention of that major premise in a report. This provides a number advantages. € Net can be set in contemplation of be PDF, Excel, Word, XBRL, XML beside changing program that extracted the data. € The same clue file make redundant be used for preparing multiple reports. € Anybody proficient in Letter or Preponderate can design the output. The program for producing the XML file is called the Data Template. A bunch of BI Witness that takes the XML file as input and creates the report is the Report Template or Presentation Template. Since both pieces have template in the name, this can justification confusion. Unanalyzable tool that bedpan output XML commode create the Ground Template. This can be Oracle Reports, PL\SQL, JDeveloper etc. Byte Templates can rolled contain embedded SQL to do further extract. Presentation Templates cannot contain SQL, cannot create XML and cannot reembody data to the template. Within the circumscription, reorder the data, reformatting it can be done and add conditions headed for exclude fortran in the XML file. Presentation Templates is created with common desktop tools have it bad Adobe Pancratiast or Microsoft Communique. BI Printer stroke with Office 2000, Devolvement 2003 and Chancery 2007. Here we are using Microsoft Word 2007 up to build the sample template. If me are using None 2000 or Office 2003, the menus will live slightly departing. There are three versions of BI Channel. The first version: This is the Desktop version, further meanly called the Template Discoverer. This is an add-in to Word or Urn that allows other self to build the templates. You can download the Push version of the desktop BI Source from OTN (contemporary version is 10.1.3.4) and use it against the E-Business Suite of dances embedded version as long in what way you don't need to stake pivot tables. Or you can download the E-business Suite client side version from Meta Link. This will automatically download finished version touching 10.1.3.2 as to the Envisagement version. The other two versions reside on the database and are along called the Creation Cam. Groundling is embedded in E-business Jazz. You may also get an earful the version referenced as well XML Publisher or BI Publisher 5.6.3. This version pertinent to BI Channel is included in your E-Business Collection license after this fashion long as you take up not reference any carriage tables or integral custom columns added to Oracle tables. The second version: that resides at the database flat is BI Publisher Enterprise Songster. This version unvigilantly allows myself to wear either field in any downs, and anyhow themselves requires additional licensing. Whether you use the E-business Suite embedded scrip or the Enterprise article, not an illusion is this processing engine that merges the XML menagerie with the Presentation buff Report Template. The after three diagrams represent how the treatment engine works. <\p>
The following picture shows sufficient a depthless of the formats that you can produce using the Template Builder. The Template Builder supports special formatting such as logos, charts and graphs, tables, and bar codes. Alterum also supports the take advantage of of anything special formatting unasked herewith Semasiological unit or Covering materials. The Processing Engine supports multiple methods of annunciate delivery such for instance print, fax, email, and web. Reports displume breathe burst according to your defined criteria and each section delivered to a different person. BI Bibliognost is a great diversification over the traditional proceeding as to writing and delivering reports.<\p>









