Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 195 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to rename Sheet1, Sheet 2....to custom names as per Business User requests
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
Answers
-
Please check if below helps:
Thanks.
0 -
Mandeep,
I`m not using RTF template. I`m using template editor.
0 -
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.0 -
Hi Team,
Please help me on this asap.
0 -
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
1 -
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.
0 -
The expections is like below
0 -
Hi Team,
Please let us know if its feasible in excel template.
Thanks,
Venkatesh.
0 -
Hi Team,
Could you please provide logic for Demand quantity column with tables.
Navigation:Supply execution—>Inventory managment—>Manage reservations and Packs
0
