How to generate a tab delimited output using BI Publisher

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.