Introduction
For a typical implementation project there is always a need to get Data from the system in different output formats like RTF, PDF, Excel, XML and many more. But at times the consuming application does prefers receiving a CSV (Comma Separated Value) file. In this article we would demonstrate how to get a Comma Separated Value file using BI Publisher in Oracle Fusion Application.
So let-us get started.
Worked Example
There are certain steps to be followed to achieve the same.
-
Creating a Data Model
-
Creating a Report
-
Making Appropriate Changes in the Report to ensure CSV Output is received
We would go through each one of the steps in detail.
Creating a Data Model
For this example, we would create a Data Model based on a sample XML file (contains dummy data).
As a first step we need to login to the application and navigate to the BI Catalog.
Once you click on the Sign In Button this will take you to the HomePage.
Once we point the mouse on the hyperlink and click on same this would take us to the ‘Reports and Analytics’ Page
Once Selected it would open a popup window
Attribute Name |
Attribute Value |
*Name |
SampleDataSet |
XML File |
Shared (Default value) |
*Data Source |
Demo files (Default value) |
*File Name |
<Left Blank as we would use Local Option> |
Local |
Enabled |
File Name |
<Local File Name which is being uploaded> |
Once we click on OK we should be able to see the next screen
Creating a Report
Once we have saved the Data Model ( we have used the name SampleDataModel for this example) we need to click on the ‘Create Report’ button and complete the layout design.
Select Use Data Model>Guide Me>Next
Create Report>Page options - Portrait> Layout - Table> Next
We need to click on the ‘Finish’ button, navigate to the specific folder location where we want to save the report, give a name to the Report and save the same.
This brings us to the end of the second step of ‘Creating a Report’
Changing Report Layout Properties to get CSV Output
If we view the report as-is (without any changes the output would appear as below)
Next we need to click on the ‘View a List’ hyperlink on top right hand side of the screen
We could see that there are multiple output formats selected currently but we need to ensure that we only select DATA(CSV) option. This would ensure we get CSV Data output.
Now hopefully once we save the report and try to view the same we should get CSV data.
And there it is.
That’s it for the day, thanks all for your time and have a nice day ahead.
Comments
I'm sending it to a few buddies ans additionally sharing in delicious.
And obviously, thanks to your sweat!
You certainly realize how to bring an issue to light and
make it important. More and more people need to read this and understand this side
of the story. I can't believe you are not more popular since you definitely possess
the gift.
keep it up.
that you can write otherwise it is complicated to write.
your contact details though?
RSS feed for comments to this post