nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BI publisher Header record displays in Uppercase.

I am generating CSV file with PIPE(|) delimiter and output looks good. However, my header record always display in Uppercase even though I defined as mixed case in the data model query. my requirement is whatever format I gave and should come same format in my CSV file.

select

FIRST_NAME 'FirstName',

LAST_NAME 'LastName'

from dual.

I am getting the following data in CSV file.

FIRSTNAME|LASTNAME

John|Doe

Lisa|flint

Joe|deflice

I want header record should be display in the mixed case format in the file.

FirstName|LastName

Really appreciate help.

Thanks

Find more posts tagged with

Accepted answers

I tested this and it does work.

Check Data (XML) too, it should be mixed case there.

Kevin

All comments

Edit the data model, under Properties (left hand pane),

Set XML Tag Display to Preserve Case and test again.

Rgds,

Kevin

Thanks for reply. I have already set that option, and it seems it is not working. is there any other option that I need to set.

Thanks

Siva

I tested this and it does work.

Check Data (XML) too, it should be mixed case there.

Kevin

Manually changed xml tags, then it is showing. Thanks for your help

Thanks

I am glad it is working now.

Kevin