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
-
Easy to create
-
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:
-
Creating a Simple Report from a Subject Area
-
Set the Properties Tab of Report to ensure we get pipe-delimited file
-
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.
-
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
Subject Area Name : Workforce Management – Person Real Time |
|
Attribute Name / Prompt |
Attribute Value / Data Source |
Person Number |
“Person Details”.”Person Number” |
Display Name |
“Person Names”.”Display Name” |
-
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
-
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
Comments
I really like what you've acquired right here, really like what you are stating and the way
in which wherein you say it. You make it entertaining and you still care for to keep it sensible.
I can't wait to read much more from you. This is really a wonderful web site.
site and in accession capital to assert that I acquire
actually enjoyed account your blog posts. Any way I will
be subscribing to your feeds and even I achievement you access consistently fast.
it consists of useful Information.
RSS feed for comments to this post