Oracle Communities

Oracle Analytics and AI

Child Item

How to rename Sheet1, Sheet 2....to custom names as per Business User requests

kalyan gade

Hi,

Business Users requests to display custom names for Sheet 1,Sheet 2.... in the excel output rendered from BI Publisher.

How do I achieve it. I am creating the report using BI Publisher Template Builder

Thanks

Kalyan

Find more posts tagged with

BI Publisher

OTBI

BI Publisher Report Templates

Accepted answers

All comments

MandeepGupta

Please check if below helps:

https://fusionhcmconsulting.com/2021/09/bip-update-sheet-name-in-rtf-template-for-excel-output/

Thanks.

kalyan gade

Mandeep,

I`m not using RTF template. I`m using template editor.

VenkateshMupparaju

Hi Team,

Am trying to add parameter sections in sheet 1.But we are not able to disciply(All parameters values are available in Group(G_2))

WHen ever trying to add another tab with parameters its getting blank

Could you please help me on this bascially this is the multi tab output(For each tab we are disciplaying one work order details.)

Template :Excel
Output:Excel
FOr your reference find the atatched xml file and excel template.

06052025DT (2).xls

HP-RPT-014 New Work Order Supply Pegging Data Model (10) (4).xml

VenkateshMupparaju

Hi Team,

Please help me on this asap.

ravikiran goda-Oracle

Hi @VenkateshMupparaju

Use XDO_SHEET_NAME_? to specify the naming convention for each sheet.

Please review the documentation

https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_excel_tmpl.htm#ext_multsheets

VenkateshMupparaju

Hi Ravi,

Thanks, for your update.

I can be able to handel multiple sheets with dynamic name as a Work order number.

But my requirment is I need to add one more tab and need to disciplay parameters values which user paseed.(These values are available in Group 2)

So that am trying to add one more tab and select the parameter columns from the xml file(Group2).Then I got the bank values.

For your reference find the attached xml file and excel template.

Thanks,

Venkatesh.

VenkateshMupparaju

The expections is like below

VenkateshMupparaju

Hi Team,

Please let us know if its feasible in excel template.

Thanks,

Venkatesh.

VenkateshMupparaju

Hi Team,

Could you please provide logic for Demand quantity column with tables.

Navigation:Supply execution—>Inventory managment—>Manage reservations and Packs