tag:blogger.com,1999:blog-4019598559914347729.post1416380210146617033..comments2024-02-09T04:19:32.395-06:00Comments on Tim Tow's Hyperion Blog: OLAPUnderground Outline Extractor on 11.1.2.1 - Updated Path RequirementsTim Towhttp://www.blogger.com/profile/01455458983202814616noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-4019598559914347729.post-76113069323113504842013-09-12T13:56:17.488-05:002013-09-12T13:56:17.488-05:00Thanks Tim your blog helped me resolve the issue o...Thanks Tim your blog helped me resolve the issue of outline extractor for 11.1.2.1shashinoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-56714668589967414962013-07-31T04:24:51.033-05:002013-07-31T04:24:51.033-05:00Thanks a lot Tim...I got it configured on a 11.1.2...Thanks a lot Tim...I got it configured on a 11.1.2.3 platform running Windows 8 / 64 bit environment Here goes my batch file- <br /><br /><br />@rem This command file uses the 8.3 filename format. <br />@rem The 8.3 filename may vary between machines, so <br />@rem be sure to check the paths carefully. Use dir /x<br />@rem to find the filenames in the 8.3 format.<br /><br />set EPMHOME=C:\Oracle\MIDDLE~1\EPMSYS~1<br />@rem ESSBAS~3 points to EssbaseRTC<br />set ARBORPATH=%EPMHOME%\common\ESSBAS~3\1112~1.0<br />set ESSBASEPATH=%ARBORPATH%<br />set ESSLANG=English_UnitedStates.Latin1@Binary<br /><br />set PATH=%ARBORPATH%\bin;%EPMHOME%\bin-32;%PATH%<br /><br />start C:\PROGRA~2\OLAPUN~1\ESSBAS~1\EXPORT~1.EXE<br />Siddhartha Nagnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-74590517048929727582013-06-27T11:13:17.178-05:002013-06-27T11:13:17.178-05:00Naren,
Please contact the Outline Extractor suppo...Naren,<br /><br />Please contact the Outline Extractor support team immediately at support@appliedolap.com.<br /><br />If you set the environment variables and run the extractor from a batch file, there should not be any way it would affect the entire EPM environment as the scope of those variables would be limited to the command instance.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-86568863788428976172013-06-27T10:44:45.598-05:002013-06-27T10:44:45.598-05:00Hi Tim,
We have a Outline extractor connectivity ...Hi Tim,<br /><br />We have a Outline extractor connectivity issue and it is fixed by creating a batch file as suggested by you.<br /><br />Unfortunately, instead of creating a new oracle home path, I have used the path where Essbase 64bit is running. Now, the EPM system Crashed. Do you have any suggestions?<br /><br />Thanks<br />NarenNarenhttps://www.blogger.com/profile/05496408722531097769noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-13458106824671868002013-05-08T13:09:54.803-05:002013-05-08T13:09:54.803-05:00Hi Aarthi,
Contact Applied OLAP support at suppor...Hi Aarthi,<br /><br />Contact Applied OLAP support at support@appliedolap.com for assistance.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-58864420460771994572013-05-08T12:23:10.569-05:002013-05-08T12:23:10.569-05:00I tried the utility for 11.1.2.2 essbase on window...I tried the utility for 11.1.2.2 essbase on windows 2008r2. we have a job that uses the exportdim.exe through a batch file. we have modelled our export in the same format as the loadsample.bat but each time it runs it throws the error- win is not recognized as an internal or external command.Aarthi Krishnanhttps://www.blogger.com/profile/07904715841282722774noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-55311254160253894982012-04-13T08:00:15.501-05:002012-04-13T08:00:15.501-05:00Not everyone will upgrade to 11.1.2.x in the near ...Not everyone will upgrade to 11.1.2.x in the near future and, when they do, they may need to extract/rebuild. Further, the xml format published by 11.1.2.x cannot currently be used to build a cube, so there will be usefulness for years to come.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-68885112424290172682012-02-23T08:17:20.166-06:002012-02-23T08:17:20.166-06:00You know there is really no reason to use this too...You know there is really no reason to use this tool in 11.1.2.x due to XML exports now being available through MAXL. On top of that when testing on a large hierarchy this tool took over 30 minutes for just the account hierarchy were as the native tool took under a minute for a full outline extract.newbishhttps://www.blogger.com/profile/12070206374981877424noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-26594727615823024592012-01-24T10:52:18.351-06:002012-01-24T10:52:18.351-06:00I haven't used IKVM yet; it was pre-version 1....I haven't used IKVM yet; it was pre-version 1.0 last time I saw it.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-27161457518147020152012-01-20T11:56:18.164-06:002012-01-20T11:56:18.164-06:00Hi Tim,
Yes I agree. We've been using the C A...Hi Tim,<br /><br />Yes I agree. We've been using the C API in this application since version 9.3 and every time it's updated to support the latest release a new problem occurs!<br /><br />I've already had a chance to play with the Java API and I found it can be incorporated into a .NET project by using IKVM. I think the java API for Essbase is well implemented.<br /><br />Not yet used web services myself but it also seems a good way of integrating the JAPI with .NET.<br /><br />Anyway, many thanks again for your help.D Clarkenoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-19917607142650477382012-01-11T07:56:13.072-06:002012-01-11T07:56:13.072-06:00I am glad I was able to help; that is the reason I...I am glad I was able to help; that is the reason I have a blog!<br /><br />BTW, the VB and C API's seem to getting harder to support. Meanwhile, the Java API is becoming more complete and easier to support. That is why we chose to use the Java API for Dodeca. The Dodeca client is written in C# and talks to our Java server via web services. Would you be interested in seeing how the Dodeca dll's could be used in your ASP.Net project?<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-90863970412201137942012-01-11T06:55:12.470-06:002012-01-11T06:55:12.470-06:00Thanks Tim. Had a similar similar problem myself o...Thanks Tim. Had a similar similar problem myself on this one in on of our ASP.NET systems that use components of the Essbase C API.<br /><br />All we had to do was add the bin-32 directory to the PATH and then it was sorted!D Clarkenoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-55355715543501740182011-11-14T09:56:23.868-06:002011-11-14T09:56:23.868-06:00We basically had the same issue but with our own A...We basically had the same issue but with our own APIs over the past few versions. Wanting to write 32 bit apis but with 64 bit Essbase. My process for servers is to install all server side applications as 1 "admin" userid. Then I take all the environment variables and move them from system to user environment variable. Then I log in as a separate user and install the client applications. The beauty of this is that if you want to you can even run multiple Essbase server instances of different versions on the same server. (of course with different port numbers)SickSkilzhttps://www.blogger.com/profile/05548564193204303895noreply@blogger.com