OneCloud offers the Convert CSV to Native Essbase Format Command. This feature, is part of the OneCloud EPM Utilities BizApp and can easily convert a tabular delimited output with or without column headers into an "Essbase Ready" Native Format. The OneCloud Command converts the delimited data, which could be sourced 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

As always, we welcome questions on this post, feel free to contact us at support@onecloud.io.

Did this answer your question?