Introduction

For those of you who have a little bit of idea about OTBI (Oracle Transactional Business Intelligence) they must also be aware that OTBI provides an easy mean of creating Reports in HCM Cloud.

By simply performing a drag-drop action individuals (technical / functional / techno-functional and even Business users) may create a Report and get the data out from the system. An added advantage of using OTBI Report here being that it has inbuilt security features incorporated (meaning individuals only will have access to records s/he is entitled to view).

However, sometimes there is also a need to use a OTBI Report for transferring data to downstream or a 3rd Party application with the added limitation that the consuming system expects a pipe delimited data file. I agree this might not be a recommended approach HCM Extract being the one suggested and widely used one but then this method has its own benefits a couple of them being

1. Easy to create

2. Logged In User only has access to data they are authorized to view

In this article, we will try to show how to create a pipe-delimited report from an OTBI Analysis (actually from a Subject Area in this case).

On a broad level, we would need to perform the below mentioned 3 steps to get a pipe-delimited report:

1. Creating a Simple Report from a Subject Area

2. Set the Properties Tab of Report to ensure we get pipe-delimited file

3. Set the Output Format and Default Format under Report Layout

So much about the theory part. Time for creating a sample report to demonstrate and establish whatever we have been promising until now.

1. Creating a Simple Report from a Subject Area

For this example, we would use the ‘Workforce Management – Person Real Time’ subject area and include just two attributes namely Person Number and Display Name

2. Set the Properties Tab of Report to ensure we get pipe-delimited file

Next, we need to click on the Properties tab of the Report

Under the Formatting Tab navigate to the CSV Output Section and Choose Pipe(|) as the CSV Delimiter under Report Value

3. Set the Output Format and Default Format under Report Layout

Now we need to navigate to the Layout section (from ‘View a List’ link)

Please ensure that ‘Data (CSV)’ is the Output Format and Default Format value on the Layout section

Now when we click on View Report we get the output in pipe-delimited format

Ashish Harbhajanka

Add comment