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)
Here it is. Easy-peasy 🙂
I hope you find it helpful.