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

Ivony Ann Paula Salango

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

https://community.oracle.com/products/oracleanalytics/discussion/24741/is-it-possible-to-remove-a-certain-field-column-from-the-output-of-csv-file-in-otbi-report

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

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

gclampitt

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

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/64397#Comment_64397

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

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

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

Nathan CCC

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