Oracle BI Publisher step by step report


Oracle BI Publisher (formerly XML Publisher)  is an enterprise-level reporting tool that separates the data from the presentation. This means that the IT department can define the data sources, and power users can specify the report layout using tools like Microsoft Word. The same data source can be used by multiple report templates.

Here are a few steps to follow:

  1. Create the program definition
  2. Create the BI Publisher (BIP) Data Definition
  3. Create the BIP Template
  4. Add the report to the needed responsibility
  1. System Administrator -> Concurrent -> Program –> Define
  2.  In the Concurrent Programs window, search for your model report. Then click Copy to button and enter report name, short name and select the Application you want to belong to. You also must check Include Incompatible Programs and Include Parameters.

    The report must be executed by XDODTEXE and also your report must have Output format XML.

  3. You must first create the XML file that extracts data from database. It has a structure similar to:

  4. This file will be uploaded into:Responsibility XML Publisher Administrator –> Home –> Data Definition -> Create Data Definition
    Application name of data definition should match the application name of your concurrent program.

  5. Create the RTF template
  6. XML Publisher provides a plug-in for Microsoft Word to facilitate the design of RTF templates. Using a combination of native Microsoft Word features and XML Publisher command syntax you can create a report template that is ready to accept XML data from your system. RTF templates can generate the following output types: PDF, HTML, RTF, Excel, XML.

    Load RTF template:
    Responsibility XML Publisher Administrator –>Home –> Templates

  7. System Administrator –> Security -> Responsibility -> Request
    Related links:

    BIP Pages –
    BIP Docs –
    BIP Downloads –
    BIP Blog
    BIP Forum –

Finally, there’s another very important peculiarity of what does Cialis that brings it so high above its alternatives. It is the only med that is available in two versions – one intended for use on as-needed basis and one intended for daily use. As you might know, Viagra and Levitra only come in the latter of these two forms and should be consumed shortly before expected sexual activity to ensure best effect. Daily Cialis, in its turn, contains low doses of Tadalafil, which allows to build its concentration up in your system gradually over time and maintain it on acceptable levels, which, consequently, makes it possible for you to enjoy sex at any moment without having to time it.

2 thoughts on “Oracle BI Publisher step by step report”
  • Ralph Thompson says:

    great post thanks

    October 18, 2010 at 6:07 am
  • MSCH says:

    nice post. thanks.

    December 8, 2010 at 9:23 pm

Comments are closed.

By continuing to use the site, you agree to the use of cookies. More information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.