tag:blogger.com,1999:blog-6575283218005807475.post5644173264765006540..comments2023-12-14T05:50:47.097-08:00Comments on More to life...: ODI Series - Extracting data from essbaseJohn Goodwinhttp://www.blogger.com/profile/03663642245534297566noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6575283218005807475.post-22029745509398301652010-08-19T10:48:19.141-07:002010-08-19T10:48:19.141-07:00You can either,
Install an agent on the essbase se...You can either,<br />Install an agent on the essbase server.<br />or make sure the agent can access the exported data.<br />In the past I have run an calc script only interface to run a data export, then copied the export file to a location where the agent can access it.<br />Or you can create an ODI procedure to call a maxl script.John Goodwinhttps://www.blogger.com/profile/03663642245534297566noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-8861105686317708502010-08-04T13:21:21.265-07:002010-08-04T13:21:21.265-07:00Hi
thanks for the wonderfull blog.
i created the ...Hi <br />thanks for the wonderfull blog.<br />i created the interface with calc script and got an error saying "Error occured while reading the data file produced by calculation script."<br />later got it, my odi and essbase server are not installed into same server.<br />and can i do the dataexport in maxl script using the same calcscript if yes plss let me know how it is done.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-51046752905685106532009-11-01T17:49:48.539-08:002009-11-01T17:49:48.539-08:00I thought the post made some good points on extrac...I thought the post made some good points on extracting data, I use python for simple extracting data,data extraction can be a time consuming process <br /> but for larger projects like files, the web, or documents i tried <a href="http://www.extractingdata.com" rel="nofollow">"extracting data from the web"</a> which worked great, they build quick custom screen scrapers, extracting data, and data parsing programsatlas245https://www.blogger.com/profile/09312104162096523556noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-10461342451121347102009-10-06T05:27:32.617-07:002009-10-06T05:27:32.617-07:00Hi John..
I feel its hard to edit and recompile OD...Hi John..<br />I feel its hard to edit and recompile ODIEssbaseDataReader.class. Do you decompile ODIEssbaseDataReader.class and all the library (including iterated library)? it's hard to do. How is the easiest way to recompile ODIEssbaseDataReader.class?<br /><br />Well, I'll thank's if you give me the compiled ODIEssbaseDataReader.class (or the odihapp_essbase.jar).. :)..<br />thank's before. This is my email address : yunianto_k@yahoo.co.id.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-88538551764623336342009-09-09T01:24:42.007-07:002009-09-09T01:24:42.007-07:00Important thing to add if you are going to use ext...Important thing to add if you are going to use extraction with CalcScript:<br />For extracting data using calculation script, the Essbase server and the Oracle Data Integrator<br />Agent must be running on the same computer.Ivanhttps://www.blogger.com/profile/07671305552398304330noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-1191095762618720022009-09-02T04:01:24.912-07:002009-09-02T04:01:24.912-07:00hi john, could you please explain the merits and d...hi john, could you please explain the merits and drawbacks of each extraction method? It will be a useful information for us. ThxUnknownhttps://www.blogger.com/profile/11235135014710998043noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-91243811920620542152009-07-28T12:22:57.781-07:002009-07-28T12:22:57.781-07:00When I create a text filed from Essbase using a ca...When I create a text filed from Essbase using a calc script command: DATAEXPORT, it generates a character at the end of each record. ODI complains reading that character. I have to open the file in wordpad and save the file to remove the characters and it then loads fine from ODIUnknownhttps://www.blogger.com/profile/07778713976788013822noreply@blogger.com