Help Desk

Submit a ticket My Tickets
Welcome
Login

Convert to Native Format Conversion

OneCloud offers the Convert CSV to Native Essbase Format Command. This Command can convert a tabular delimited output with or without column headers into a native "Essbase Ready" Native Format. The command converts the delimited data which could be source from a relational query into a format that can be directly loaded into a variety of Oracle EPM products including Oracle Essbase, Oracle EPM Cloud technologies. Below are some two sample source formats and the corresponding output. 

Multiple Data Columns and Header

Sample Configuration

Source

Measures  Product  Market  Scenario  Jan  Feb  Mar  Apr  May  Jun  Jul  Aug  Sep  Oct  Nov  Dec
Sales  100-10  New York  Actual  675.00  0  675.00  712.00  756.00  890.00  912.00  910.00  790.00  650.00  623.00  699.00
Sales  100-10  New York  Budget  999.00  610.00  640.00  670.00  710.00  840.00  860.00  860.00  750.00  540.00  560.00  620.00
COGS  100-10  New York  Actual  271.00  258.00  270.00  284.00  302.00  356.00  364.00  364.00  316.00  260.00  249.00  279.00
COGS  100-10  New York  Budget  0  240.00  250.00  270.00  280.00  340.00  340.00  340.00  300.00  210.00  220.00  250.00

Converted

        "Jan"  "Feb"  "Mar"  "Apr"  "May"  "Jun"  "Jul"  "Aug"  "Sep"  "Oct"  "Nov"  "Dec" 
"Sales"  "100-10"  "New York"  "Actual"  675.00  #Mi  675.00  712.00  756.00  890.00  912.00  910.00  790.00  650.00  623.00  699.00 
"Sales"  "100-10"  "New York"  "Budget"  999.00  610.00  640.00  670.00  710.00  840.00  860.00  860.00  750.00  540.00  560.00  620.00 
"COGS"  "100-10"  "New York"  "Actual"  271.00  258.00  270.00  284.00  302.00  356.00  364.00  364.00  316.00  260.00  249.00  279.00 
"COGS"  "100-10"  "New York"  "Budget"  #Mi  240.00  250.00  270.00  280.00  340.00  340.00  340.00  300.00  210.00  220.00  250.00 

Single Data Column and No Header and Single Column of Data

Sample Configuration

Source

Jan  Sales  100-10  New York  Actual 675.00
Feb  Sales  100-10  New York  Actual  645.00
Mar  Sales  100-10  New York  Actual  675.00
Apr  Sales  100-10  New York  Actual  712.00
May  Sales  100-10  New York  Actual  756.00
Jun  Sales  100-10  New York  Actual  0

Converted

"Jan"  "Sales"  "100-10"  "New York"  "Actual"  675.00 
"Feb"  "Sales"  "100-10"  "New York"  "Actual"  645.00 
"Mar"  "Sales"  "100-10"  "New York"  "Actual"  675.00 
"Apr"  "Sales"  "100-10"  "New York"  "Actual"  712.00 
"May"  "Sales"  "100-10"  "New York"  "Actual"  756.00 
"Jun"  "Sales"  "100-10"  "New York"  "Actual"  #Mi


Login to post a comment