PDF Password Protection in BI Publisher
Go to File->Info->Properties>Advanced Settings and follow the Screen shot A and Screen shot b Screen shot A In the Custom Tab add one XDO as xdo-pdf-open-password and in the value filed type the…
Read MoreBI Publisher Report with Excel Template
Step1:Concurrent Program Create a Concurrent Program with Exceutable File Name as XDODTEXE Step:2 Data Xml Template Create a Data Xml Template for the Query Step:3 Data Definitions Create a Data…
Read MoreOracle BI Publisher Introduction
Oracle XML/BI Publisher is a very good reporting tool, which outputs reports into many formats like Word, Excel, PowerPoint, PDF and even to Adobe Flash. This can deliver reports generated from XML/BI Publisher to many destinations like email, fax and printer using the standard API’s.Create a template to lay out the data in a report, and publish the report to numerous output formats. BI Publisher also enables to schedule reports and deliver the reports to any delivery channel required as per the business need.A report consumer may perform the following tasks: Run and view reports from the BI Publisher reports repository Schedule reports to run at selected intervals and to be delivered via any channel set up by your administrator Create an ad hoc analysis of report data using BI Publisher’s Analyzer feature Open and manipulate reports in Microsoft Excel using BI Publisher’s Analyzer for Microsoft Excel Process to generate the reportThe report attributes, what needs to display should be stored in database table. We can select the values from table and display as a report as per input template.Design the TemplateMicrosoft word is very useful to create the template for report designing. Design the template as per report need and add the database fields in the corresponding areas so that the report will be displayed in neat format. Name Job Title Department Name Salary F Odd Row:NAME JOB DNAME SAL Even Row:NAME JOB DNAME SAL E TOTAL (The template file should be stored as rich text format (rtf) file.)
Read MoreOracle BI Publisher Desktop
Making the relationship between Microsoft word and BI Publisher will be very convenient for template designing part. Because by using Microsoft word, user can draw the tables and they can do lots of designing parts.To enable the BI Publisher tool bar in to Microsoft word, we need to install the plug-in.To aid in the building of RTF templates BI Publisher provides the BI Publisher Template Builder for MSWord. Prior to starting the examples we should download this plug-in and install it. This is available from metalink; the latest version is 5.5 and can be found by downloading patch 4561835. Alternatively we can install from the BI Publisher window itself. We can install by clicking on the Template Builder link in that above picture. After that the add-ons will be installed and BI Publisher menu will be enabled in Microsoft word document. Add-Ins has enabled and displayed in word like the other optionsUnder the Add-Ins following tab has enabled. l Oracle BI Publisher l Data l Insert l Preview l Tools l Help By using the above method to enable Oracle BI Publisher add-ins in Microsoft word.
Read MoreConfiguring APEX to use BI Publisher
To use BI Publisher as your Report Server, first, access the Report Printing parameters:Go to The following navigation in APEX with Admin credentials. 1 Access the Administration Services home page 2 Select Manage Service 3 Select Instance Settings, under Manage Environment Settings 4 Click Report Printing to focus on just the Report Printing attributes Now, specify the following attributes: Oracle BI Publisher: Advanced Support Print Server Protocol: HTTP or HTTPS (depends on your configuration) Print Server Host Address: the hostname for the machine where you installed BI Publisher – e.g. myhost.mycompany.com Print Server Port: the port given at the end of the BI Publisher installation – e.g. 9704 Print Server Script: /xmlpserver/convert
Read MoreBI Bursting
One of the very good features of Oracle BI Publisher is its ability to burst and send the reports to multiple users simultaneously.Using BI Publisher’s bursting feature we can split a single batch report into individual reports to be delivered to multiple destinations. We can apply a different template, output format, delivery method, and locale to each split segment of our report. Example implementations include: Invoice generation and delivery based on customer-specific layouts and delivery preference Financial reporting to generate a master report of all cost centers, bursting out individual cost center reports to the appropriate manager Generation of pay slips to all employees based on one extract and delivered via e-mail Enabling a Report for BurstingPrerequisite: A report defined in BI Publisher. The report data must contain an element by which the report will be split and an element by which the report will be delivered.Enabling a report for bursting consists of the following steps: Open the report in Edit mode. Select Bursting under the report definition. Select the Enable Bursting check box. Select the Split By and Deliver By elements. The Split By element is the data element from the report file that you wish to split the report by. For example, to split a batch of invoices by each invoice, you may use an element called CUSTOMER_NAME.The Deliver By element is the data element from the report file by which to determine the delivery method. In the invoice example, it is likely that each invoice will have delivery criteria determined by customer; therefore the Deliver By element may be CUSTOMER_ID. Select the data source for the delivery XML. The delivery XML can be sourced from the same data source as the main data set, or it can be generated from a different data source. Enter the SQL query to build the delivery XML. See Defining the Delivery Data Set for details. Defining the Delivery Data SetBased on the SQL query that we provide on the Bursting criteria page of the Report Editor, BI Publisher will build the delivery XML data set. The delivery XML data set contains the information to deliver the burst report appropriately to each recipient. The delivery data in this XML document is used as a mapping table for each Deliver By element. The structure of the delivery XML is as follows: Where KEY is the Delivery key and must match the Deliver By element. The bursting engine uses the key to link delivery criteria to a specific section of the burst data. TEMPLATE – is the name of the Layout template to apply. Note that the value is the Layout name (for example, “Invoice”), not the template file name (for example, invoice.rtf). TEMPLATE_FORMAT – is the format of the layout template. Valid values are: o RTFo PDFo ETEXTo XSL_FO LOCALE – is the template locale, for example, “en-US”. OUTPUT_FORMAT – is the output format. Valid values are: for example: pdf, html, excel. o HTMLo PDFo RTFo EXCEL DEL_CHANNEL – is the delivery method. Valid values are: o EMAILo FAXo FILEo FTPo PRINTo WEBDAV Delivery parameters by channel. The delivery parameters by channel are defined in the following table: Parameter Mapping
Read More