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

Fusion HCM Tricks: How to embed BI Publisher Report into Performance Document

Introduction

Fusion HCM is another big and very interesting area with which I work.
In this post I would like to tell about Fusion Performance Management Solution and about some tricks how to make Performance Documents in the system more friendly by designing templates which fits requirements from customers. Continue reading