1. Oracle Bi Publisher Excel Template Pivot Table
2. Free Excel Template

Aug 19, 2014 - I never had an opportunity to design an Excel (XLS) template for BI Publisher (BIP), as it was not a requirement at many of our clients.

I need to filter Excel Template. which is XML BI Publisher report. Report Filter Condition is CATEGORY=('1002')

please advice where to put filter or how to filter the Excel Template.

Thanks in advance

2 Answers

You could put the filter in the for-each loop of your RTF template. If done that way, only those records which match the criteria would make it to the Excel output. The user would have no way of removing the filter.

There are a few ways you can do this:

1.) Filter in the SQL, I find this to be the easiest way, but it may not be the best option for this scenario

2.) Filter in the RTF with the for-each statement like @EdHayes3 answered. That would look something like this:

3.) Create a Pivot table that references the your data. Then you can add explicit filters using the normal Excel Pivot table methods. I followed this example with great results: https://blogs.oracle.com/xmlpublisher/adding-native-pivot-charts-and-tables-to-your-excel-reports .

There may be a way to add a filter to the excel report without a pivot table. If so, I'd love to hear from someone who has done this.

Oracle Bi Publisher Excel Template Pivot Table

Not the answer you're looking for? Browse other questions tagged bi-publisher or ask your own question.

Free Excel Template

'I need to apply link to a column values in the excel template pivot table.
In my requirement of bi publisher report. My report is based on excel template.
I have two sheets, one is base report(sheet 1) and another one is pivot report(sheet 2).The pivot tables(sheet 2) is created from the base report columns(sheet 1). I need to apply link to one of the column of pivot table for example, order_no column, if i click the particular order_no , it will open another report with respective of this order_no(as a parameter).
In the XDO_METADATA file i applied code for that.But the link only applies to the base report(sheet 1) Order_no instead of Pivot table(sheet 2) Order no. How to apply the link to the particular sheet(pivot table).

The XDO_METADATA file code
XDO_LINK_?ORDER_NO? -- http://vthamila-in.in.oracle.com:9704/xmlpserver/TEST/test2/test2.xdo?P_order_no=',./ORDER_NO)'/>
Excel version-2007

In tat above code- test2.xdo is my new report which have to open when clicking the order_no link.

I don't know how to specify link to the Pivot table (sheet 2).'