Creating Pipe Delimited file using OTBI Report

Step by Step Guide to Create a Pipe delimited file using OTBI analysis

Creating Pipe delimited file using OTBI Report

– By Amitesh Kumar

There are instances when we want to create a simple pipe delimited file for integration purpose and don’t want to use RTF template or write complex SQLs in BI Publisher to achieve the same. Oracle provides a quick way to use an analysis as a data source instead of SQL and the interactive viewer to create a pipe delimited file. Following are the steps:

  1. Create an Analysis

 

Navigate to ‘Report & Analytics’ from the ‘Navigator’ screen and  Click on ‘New’ and select ‘Analysis’

 

Select ‘Person Real Time’ Subject Area (Complex OTBI reports can be created by joining subject areas)

Drag and Drop the fields needed and save

 

2.  Create a Data Model

 

Click on ‘New’ and select ‘Data Model’ from the drop down

 

Select ‘Oracle BI Analysis’ as a Data Source under ‘Data Sets’

 

Select the OTBI analysis created in the above step. Leave the ‘Time Out’ field as blank. The field is used in to limit the processing time for an analysis if the process is taking too long at runtime

 

Save the data model.

View the data and save the result as a sample data

Click on ‘Create Report’

 

3. Create a Report

 

Follow the train stop and drag and drop the field from the Data model to Create a report

 

Click on Property and scroll down to select Pipe as ‘CSV Delimiter’ and ‘True’ for ‘Remove Leading and Trailing White space’ field

 

 

Click on ‘view list’ and Deselect all the formats under ‘Output Formats’ column and select only ‘Data (CSV)’

 

 

Click on ‘Save’ icon and view report

 

As you can see the above report is in pipe delimited format and can be either exported or copied onto a notepad. The report can be scheduled just like any other BI Publisher report to place the file on an FTP server. As you will notice, the header for the file above shows generic values, the header name can be changed in ‘Data Model’ to reflect the correct column names.

 

August 1, 2017

1 responses on "Creating Pipe Delimited file using OTBI Report"

Leave a Message

ERPWebTutor
2011-2017, All rights reserved © A part of the Orison Consulting Group
PO Box 16014 San Juan Puerto Rico 00908
Email: [email protected]
Terms of Use
Contact Us
close slider

Contact