This content has been marked as final. Show 4 replies
From 9.3.0 you have the DATAEXPORT calculation script command to write directly to a relational database via ODBC. For 9.3.1, see http://docs.oracle.com/cd/E10530_01/doc/epm.931/html_esb_techref/calc/dataexport.htm.1 person found this helpful
How about ASO cube? There is no equivalent DATAEXPORT Command in ASO ... i read somewhere that Star integration server can do it though. But other than that, any more option in 9.3.1.
I think it watching out with 9.3.1 as I am sure there are a few bugs with dataexport, also if you are on 64bit essbase then I dont think the export to relational works to well1 person found this helpful
It may be possible to use XML/A from PL/SQL. Essbase.ru has a Google Code project out there for it but I'm pretty sure that was created for 11, so whether that approach could work in 9.3.1 I'm afraid I have no idea (XML/A was at least part of Provider Services then). Essbase.ru's blog is (reasonably enough!) written in Russian - not sure about the documentation, if any, that's in the Google Code project - but at least for the blog entries Chrome will translate on the fly to the point where it's readable in English. Haven't used it but I admire the effort / skill involved!
You could also write an API program or use the Perl module with MaxL to execute an MDX query and parse/ push the results.
All these options sound like a lot of work, unless you have a really, really strong reason to want to avoid creating that file...