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

Output CSV format for a BI Publisher file as per template

User_YW4G1

Hi all,

When we export a CSV file from BI Publisher Reports, it takes all the columns available in the data model, as well as the name of the columns.
Hence, when we select the CSV format as the ouput, it doesn't follow the template format of report.

I need to know if it is possible to export my report as CSV file with the fields that I added into the report template, and not every column of the data model.

For information :
Oracle Version : 24D (11.13.24.10.0)

There is bursting with my report. I used a rft template, and upload it as an eText Type.

I appreciate every suggestion, answer or advise in how I can have a CSV output file with correct data in this situation. If is not possible, I would also appreciate an answer.

Thank you all in advance.
Regards,

Paris Flores

Find more posts tagged with

BI Publisher

Report Output

Accepted answers

Bhaskar Konar

Hi @User_YW4G1,

If it is a RTF Template and then downloading as CSV, it'll ignore the Template and download all columns in the Data Model.

Please take a look into the following Oracle document which might be helpful for understanding & getting the work around.

https://support.oracle.com/knowledge/Oracle%20E-Business%20Suite/2506342_1.html

Hope this help.

Cheers,

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24203/output-csv-format-for-a-bi-publisher-file-as-per-template

Hi,

This is the expected behavior when downloading the data as csv directly. There is already an idea submitted for similar requirement. Please go through the idea, evaluate it and upvote if you will it will be helpful:

Allow report with eText template to output a report to csv with the same structure — Oracle Analytics

Thanks.

All comments

Bhaskar Konar

Hi @User_YW4G1,

If it is a RTF Template and then downloading as CSV, it'll ignore the Template and download all columns in the Data Model.

Please take a look into the following Oracle document which might be helpful for understanding & getting the work around.

https://support.oracle.com/knowledge/Oracle%20E-Business%20Suite/2506342_1.html

Hope this help.

Cheers,

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24203/output-csv-format-for-a-bi-publisher-file-as-per-template

Hi,

Allow report with eText template to output a report to csv with the same structure — Oracle Analytics

Thanks.

User_YW4G1

https://community.oracle.com/products/oracleanalytics/discussion/comment/62366#Comment_62366

Hi,

Thank you very much for your answer and for the Oracle document. Indeed, it is the solution that I have been doing since last year - RTF Template, type eText. In the bursting query, I declare the output of the file to be CSV, and the file that arrives in the repertory is correct, type of file CSV and with the correct content.

Thank you again for your answer.

Regards,
Paris Flores

User_YW4G1

https://community.oracle.com/products/oracleanalytics/discussion/comment/62376#Comment_62376

Hi,

Thank you very much for your answer. I have upvote the idea.

Regards,
Paris Flores

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/62384#Comment_62384

Hi Paris,

That's great news; glad to hear that.

Would you mind selecting the best answer that helped you to get the resolution for this issue. It'll be helpful for the fellow community members in future.

Thank You!

Cheers,