BI publisher Header record displays in Uppercase.

pepala

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

Kevin M-Oracle

I tested this and it does work.

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

Kevin

Kevin M-Oracle

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

Set XML Tag Display to Preserve Case and test again.

Rgds,

Kevin

pepala

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

pepala

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

Thanks

Kevin M-Oracle

I am glad it is working now.

Kevin