I'm trying to load Essbase data into Oracle by using ODI.
I want to use CalcScript to extract data, and I write such script
SET DATAEXPORTOPTIONS
{
DATAEXPORTLEVEL ALL;
DATAEXPORTDYNAMICCALC OFF;
DATAEXPORTNONEXISTINGBLOCKS OFF;
DATAEXPORTDECIMAL 2;
DATAEXPORTDIMHEADER ON;
DATAEXPORTOVERWRITEFILE ON;
}
FIX("FY17",@IDESC("Revenue Account"),@IDESC("YearTotal"))
DATAEXPORT "FILE", "C:\TEST"
ENDFIX
My Fix statement include two dense dimension: Account and Period. The result of the script is all period in one row, which can not be loaded into Oracle table. I want them output in 13 rows seperately, each period in one row.
eg:
"FY17","Total Revenue",20.5,20.5,20.5,20.5,20.5,20.5,20.5,20.5,20.5,20.5,20.5,20.5,246
which I need like this:
"FY17","Total Revenue",20.5
"FY17","Total Revenue",20.5
"FY17","Total Revenue",20.5
......
"FY17","Total Revenue",246
Can anybody help me on this? Really thx.