Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP SQL based report - RPAD fixed length not working in CSV output if field does not have any values
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.
Comments
-
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.
0 -
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.
0 -
Thanks for clarifying. As a workaround, you can create an eText template to satisfy your requirements.
Upvoted the idea.
Thanks.
0
