Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Output CSV format for a BI Publisher file as per template
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
Best Answers
-
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.
Hope this help.
Cheers,
2 -
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:
Thanks.
1
Answers
-
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 Flores1 -
Hi,
Thank you very much for your answer. I have upvote the idea.
Regards,
Paris Flores0 -
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,
0