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
Did this answer your question?