Oracle BI Publisher Desktop is provided by Oracle to aid in development of BI Publisher templates from your desktop with or without connection to BI Publisher Server.
When we install it, it comes with demos in flash, Sample XML data file with sample templates, PDF help for BI Publisher and plugin for MS Word.
Plugin in MS Word look something like as follows:

It can be downloaded from Oracle site.

Bookmark this post

[…]

[Read more →]

Today I create my second report using group above and group left.
I also used sum function in this report.
First I loaded XML data as before.
My XML data structure is as follows:

My intention is to design a summary report of total sale by year and month.
Run Table Wizard as follows:

Follow the following steps in Wizard:

Once clicked the result will be as follows:

Now I deleted whole Table inside the inside second column of second row of main table.
Now it should look like as follows:

Now keep you cursor inside second column of second row of main table.
Now goto Choose Field menu as follows:

Choose […]

[Read more →]

Today I went through BI Publisher Desktop Tool , used for designing report template for BI Publisher.
With my 8+ years of experience in Oracle Reports, while designing this sample template I felt as I am designing it in Oracle report.
Over all, it left a good impression on me, so I though of sharing my experience of designing my first report for BI Publisher.
Before starting we need to install a BIPublisherDesktop plugin for ms word. Once done we can start the ms word and can see the BI Publisher related menus under addon.
Step 1: Under Oracle BI Publisher under add on. […]

[Read more →]