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

BIP SQL based report - RPAD fixed length not working in CSV output if field does not have any values

User_ODHR1

Hello,

Raising Enhancement request for SR 3-39715167181 : BI Publisher SQL based report - RPAD fixed length not working in CSV output

We are using RPAD to ensure a fixed-length output. The issue is that when a column has a value, RPAD fixed-length for that column works correctly, but when the column value is NULL, it doesn't work as expected. However, our expectation is all columns to have a fixed length, regardless of whether they contain a value or are empty

Also the generated xml has the spaces. But during report generation in csv, those spaces are ignored if the value has just the spaces. We think that functionality needs to be changed, hence raising an enhancement request . Kindly check and provide an update in timely manner.

Thanks.

Find more posts tagged with

publisher

Needs Votes

Oracle BI Publisher

Status: Needs Votes

Comments

MandeepGupta

Hi @User_ODHR1 ,

Welcome to the Oracle Analytics Community.

Can you please share what kind of template you are using to generate csv? Have you tried eText template as a workaround?

Thanks.

User_ODHR1

Hi @MandeepGupta

We are using sql query in bip data model to develop a bi publisher report and to get export it in csv output format with pipe delimiter as per client's requirement.

And we are not using any template for this sql based reports. The issue is that when a column has a value in DB, then RPAD fixed-length for that column works correctly while see in csv output, but when the column value is NULL in DB, RPAD fixed-length doesn't works instead we are getting only single space.

Thanks.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/64613#Comment_64613

Thanks for clarifying. As a workaround, you can create an eText template to satisfy your requirements.

Upvoted the idea.

Thanks.