Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exporting Essbase data by CalcScript

823687Jan 13 2012

Hello, everyone

I can't export data from Essbase cube using ODI:

- some of dimensions contain spaces, for example, "Business Direction", "Cost Center". So when I add such dimension into header of EXTRACT_DATA_FILE_IN_CALC_SCRIPT, I get an error: "The first row in the data file should contain the dimension header. Please make sure that in your calculation script the DataExportDimHeader option is turned on". Quotes don't help.

- cube doesn't contain Measures. It has only "Data" in the model. So when I try to add "Data" into header of EXTRACT_DATA_FILE_IN_CALC_SCRIPT, I also get an error: "The first row in the data file should contain the dimension header. Please make sure that in your calculation script the DataExportDimHeader option is turned on".

Please, help.

Best regards,
Andrey

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2012

Added on Jan 13 2012

#business-intelligence-applications, #data-integrator, #system-management-and-integration

0 comments

137 views