My Oracle Support Banner

OBIEE BI Publisher: Header Labels Become Blank When Split The Sheet In Excel Template (Doc ID 2446429.1)

Last updated on MAY 31, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c to 12c [Release 12.0]
Information in this document applies to any platform.

Goal

On 12c version, Designing Layout Templates

OBIEE BI Publisher: Header Labels Become Blank When Splitting the Sheet in Excel Template

SCENARIO
The split to multi sheet for the Excel Template works, but the report and column headers become blank.
I believe the reason for this is that I apply the field value to be the column names and report name.
The reason I do that is to handle translation in the SQL, however, it does not work when the data is split into multiple sheets.

QUESTION
Can you advise on how this can be fixed, so the column headers are not blank?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.