Hi community,

I just want to share a useful finding I have discovered recently. The requirement was to generate a tab delimited output from Oracle HCM Cloud database to deliver a file to an outbound integration.
Earlier I used eText templates to do similar transformations but it can be achieved without it.

Let’s go through the steps do demonstrate it:

• Create a BIP data model based on the simple query

Here is an output

• Create a BIP report

• Open “Report Properties>Formatting(Tab)”

Scroll down to the CSV Output properties and set the CSV Delimiter property to Tab(\t). You might as well set it to Pipe(|):

• Set a Default Format -> Data(CSV)

That’s it.

Here it is. Easy-peasy 🙂

I hope you find it helpful.

SY,
Volodymyr