Is it possible to remove a certain field/column from the output of CSV file in OTBI report?

Ivony Ann Paula Salango · Feb 27, 2025 10:51AM

Hi,

Good day! I have a problem with a business requirement where-in some IDs in the data model are being extracted when the report is exported in CSV file format.

As you can see, these are IDs connecting the DM. In the report's layout the highlighted IDs are not included. But when we are exporting in CSV, the IDs are being extracted.

DM screenshot:

Output screenshot:

Is there a way where I can remove these IDs from the CSV output?

I hope you can help me solve this. Thank you!

MandeepGupta · Feb 27, 2025 10:59AM

Is it possible to remove a certain field/column from the output of CSV file in OTBI report?

Ivony Ann Paula Salango

Feb 27, 2025

Hi,
Good day! I have a problem with a business requirement where-in some IDs in the data model are being extracted when the report is exported in CSV file format.
As you can see, these are IDs connecting the DM. In the report's layout the highlighted IDs are not included. But when we are exporting in CSV, the IDs are being extracted.
DM screenshot:
https://us.v-cdn.net/6037859/uploads/E54N8KFLGLVS/image.png
Output screenshot:
https://us.v-cdn.net/6037859/uploads/0MCD95GDI9YB/image.png
Is there a way where I can remove these IDs from the CSV output?
I hope you can help me solve this. Thank you!

Hi Ivony,

As CSV is a data format, so it is dependent upon the data model. As there is no template, you can't hide the ID columns.

But if you don't need IDs, you can remove them from the select clause in data model or create an Etext template.

Thanks.

Ivony Ann Paula Salango · Feb 27, 2025 11:00AM

Hi @MandeepGupta , what is an Etext template? Sorry, I am not familiar with that yet.

gclampitt · Feb 27, 2025 11:01AM

hi yes - how have you created the report? just take it out of that.
eg if via the GUI, just don't include it - person_id excluded in example below

Or if created a RTF template just don't included those fields don't want in the template

Ivony Ann Paula Salango · Feb 27, 2025 11:05AM

Hello @gclampitt , the IDs are not included in the report layout that's why I can't understand how is it still being extracted with the CSV output.

MandeepGupta · Feb 27, 2025 11:06AM

Ivony Ann Paula Salango

Feb 27, 2025

Hi @MandeepGupta , what is an Etext template? Sorry, I am not familiar with that yet.

It is a type of template only where you can get csv/txt output format as per you need. Check below link:

Creating eText Templates

Thanks.

Nathan CCC · Feb 27, 2025 11:24AM

Ivony,

Output format Data CSV and Data XML ignore your selected layout template.

They will always get all columns in your data model in the order in your data model diagram no matter what you have done in any of your layout templates.

The only thing you can do is set the data model property for pruning which for example will exclude a column in your CSV/XML if all rows are empty to make the file size as small as possible. This will not help you since I assume your id fields are mandatory fields for unique identifiers.

Oracle® Fusion Middleware
Data Modeling Guide for Oracle Business Intelligence Publisher
12c (12.2.1.2.0) E77720-02 December 2016

Setting Data Model Properties

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-890FCA3E-24EE-425B-A65B-76BAF98C1C1B.htm

Ivony Ann Paula Salango · Feb 27, 2025 1:59PM

Hi @Nathan CCC , do you think there is no possible way for this requirement now?

Nathan CCC · Feb 27, 2025 2:41PM

As Mandeep said you can do it using delimiter-based (EDI templates) eText template to build a CSV using a template. That way you only have the cols you need in your CSV.

Oracle® Fusion Middleware
Report Designer's Guide for Oracle Business Intelligence Publisher
12c (12.2.1.2.0) E77722-02 December 2016 "Creating eText Templates" https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-8ADD70BC-FB9B-4145-8020-E74FE256839C.htm

Oracle Transactional Business Intelligence

Welcome!

Quick Links

Categories

Is it possible to remove a certain field/column from the output of CSV file in OTBI report?

Welcome!

Answers

Is it possible to remove a certain field/column from the output of CSV file in OTBI report?

Welcome!