Search from 700 + Posts

Mar 24, 2010

XML Publisher /BI Publisher Report .

This Post is about  XML Publisher Reports

XML Publisher /BI PublisherBI Publisher (XML Publisher) is one awesome tool introduced by Oracle Corp. It has made report designing a very easy and simple (especially for E-Business reports).

With BI Publisher
We can design Complex Reports in less time (Business User can design the layout with an easy Desktop Tool like Microsoft word/Excel /Adobe etc).
Cost of maintenance will be low.
Total Cost of design and Maintenance will be low.Here we can leverage the workdone by the functional Analyst by utlizing his/her layout design.Technical Analyst in this case has to focus on data model and then mapping the data with the Layout desgined ny Functional analyst.My Exerience says that on an average an IT analyst spend 40% time in layout design.With BI Publisher we can cut that to 10-12%.

With BI Publisher we can Design
Check Printing Reports
Labels
Customer Facing Reports (Invoices etc).
It supports data from the multiple sources e.g. Oracle, Sql Server, People soft, Java etc.
Print the output in pdf, rtf, Excel, HTML etc. format.
Route the report to Fax, email, printer etc.

Examples of Reports in BI Publisher



Other Advantages of BI Publisher is, it separate
  • Query (Retrieve data from data base)
  • Layout (Layout based on the business Requirement)
  • Translation (Translate to Multiple Language)As shown in diagram

This is very Useful for Customer who are using
1. Oracle E-Business Reports (R11i/R12)
2. Oracle Reports.

Apart from replacing “Oracle E-Business Reports “ the BI Publisher provide an opportunity to convert there existing Oracle 6i/9i /10g reports into BI Publisher reports. Oracle has reported that lots of Oracle 6i/9i/10g customers are migrating to BI Publisher.

In my example, I took the Oracle Standard Report “Comprehensive Order Detail Report” and redesign with BI Publisher, Final output is much more productive than Original Report.


Oracle E-Business Standard Comprehensive Order Detail Report


Same Report when design in BI Publisher (Please Note that this is just an example, I have not mapped everything in BI Publisher Report).

14 comments:

  1. I am thankful to this blog giving unique and helpful knowledge about this topic. Target & Bidder Statements

    ReplyDelete
  2. The legitimacy of the discoveries has been affirmed by cross-checking with different wellsprings of data. The whole procedure of the innovative work of the report additionally draws on the related knowledge of scientists and contributions from industry specialists. Data Analytics Course in Bangalore

    ReplyDelete
  3. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  4. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  5. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  6. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    data science interview questions

    ReplyDelete
  7. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  8. very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  9. I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  10. I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  11. very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Logistic Regression explained
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm

    ReplyDelete
  12. very well explained .I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Simple Linear Regression
    Correlation vs covariance
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete