tag:blogger.com,1999:blog-6575283218005807475.post6790577327222590084..comments2023-12-14T05:50:47.097-08:00Comments on More to life...: ODI Series - Will the real ODI-HFM blog please stand up.John Goodwinhttp://www.blogger.com/profile/03663642245534297566noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-6575283218005807475.post-35400533860183248122013-02-06T13:50:32.574-08:002013-02-06T13:50:32.574-08:00Hi John,
I was wondering to extract the data for ...Hi John,<br /><br />I was wondering to extract the data for all the base members of Account or Entity dimension at a go in ODI. I know we can provide the members as comma seperated values, but say my Entity dimension has 20000 member and I need to extract data for all the members at a go, what is the best way to proceed. Please suggest. sailendra Tnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-23131101169599237632012-01-10T23:33:07.010-08:002012-01-10T23:33:07.010-08:00Hi John,
Thanks for the blog and info. All your ...Hi John,<br /><br />Thanks for the blog and info. All your blogs have been extremely helpful. I was able to get past this issue after following all your directions. I did notice that the path for the snpsagent.conf file is off as it is missing a period:<br /><br />currently you have: wrapper.java.library.path.1=./drivers<br /><br />it should be: wrapper.java.library.path.2=../drivers<br /><br />It took me a few hours to figure that out as I was able to reverse the application using the Local Agent but not using the windows service agent.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-79982107440320803382011-10-21T13:08:39.741-07:002011-10-21T13:08:39.741-07:00Like your blog.. Do you have tips on how to extrac...Like your blog.. Do you have tips on how to extract full metadata from LCM on an HFM 11 environment? I'm looking for all dimensions, members, attributes and hierarchies in .ads format?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-74998644873534261142011-06-09T08:38:04.226-07:002011-06-09T08:38:04.226-07:00Hi Jonh,
I have the same issue http://4.bp.blogsp...Hi Jonh,<br /><br />I have the same issue http://4.bp.blogspot.com/__2AaArK5lW8/S3gNEJtNZTI/AAAAAAAACDM/mF8-gGc06zU/s1600-h/17.png <br />with ODI 11.1.1.3. We need another patch to solve that? Because in this post you mention ODI 10.1.3 version.<br /><br />Thanks. <br /><br />Fernando Parra. Buenos Aires, ArgentinaFernando Parrahttps://www.blogger.com/profile/08577505444553051860noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-31674611975548203962011-03-08T07:09:28.254-08:002011-03-08T07:09:28.254-08:00We got our issue fixed where HFM reverse was closi...We got our issue fixed where HFM reverse was closing the designer. <br /><br />We had ODI driver path listed in environment but HFM with ODI is strictly looking to HFM ODI driver path. Once we explicitly listed HFM driver path in variables, the issue was resolved.Amitnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-41770011083189572342011-03-07T13:27:57.797-08:002011-03-07T13:27:57.797-08:00Hi John,
One more question I was able to reverse ...Hi John,<br /><br />One more question I was able to reverse HFM by changing the environment variables path. In fact, HFM drivers are installed in a different folder (other than ODI_Home1\oracledi\drivers). However now I can't reverse HP (is it because it's drivers in another folder?)<br /><br />I get the following error:<br /><br />org.apache.bsf.BSFException: exception from Jython:<br />Traceback (innermost last):<br /><br /> File "", line 32, in ?<br /><br />com.hyperion.odi.common.ODIHAppException: com.hyperion.odi.planning.PlanningConnectionFactory{app.planning.factory.class=com.hyperion.odi.planning.PlanningConnectionFactory, app.essbase.factory.class=com.hyperion.odi.essbase.EssbaseConnectionFactory, app.hfm.factory.class=com.hyperion.odi.hfm.HFMConnectionFactory}<br /><br /><br /> at com.hyperion.odi.connection.HypAppConnectionFactory.getFactory(Unknown Source)<br /><br />...<br /><br />Thank youMarynoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-72673909424151017022011-03-05T10:33:06.220-08:002011-03-05T10:33:06.220-08:00Hi Amit,
Have you tried reversing using different...Hi Amit,<br /><br />Have you tried reversing using different agent instead of the local agent.John Goodwinhttps://www.blogger.com/profile/03663642245534297566noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-46712250195893713022011-03-04T12:13:12.355-08:002011-03-04T12:13:12.355-08:00John,
I got ODI configured with HFM. However, onc...John,<br /><br />I got ODI configured with HFM. However, once I click reverse, the designer closes automatically and the reverse process never works. Out of 3 steps, reset metadata completes but gets stuck on second step 'Reverse'.<br /><br />What can we try?Amitnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-75187972850006685922011-03-03T11:20:56.227-08:002011-03-03T11:20:56.227-08:00Hi Mary,
You shouldn't need to install the pa...Hi Mary,<br /><br />You shouldn't need to install the patch as you are already using a patch version higher than 9285774John Goodwinhttps://www.blogger.com/profile/03663642245534297566noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-75152571897391927402011-03-02T14:15:00.884-08:002011-03-02T14:15:00.884-08:00Hi John,
I get the error you mentionned needed a ...Hi John,<br /><br />I get the error you mentionned needed a patch:<br /><br />File "", line 38, in ?<br /><br />com.hyperion.odi.common.ODIHAppException: Error occurred in driver while connecting to Financial Management application [ ] on [ ] using user-name [ ]. <br /><br />However I am working with ODI v.10.1.3.5.6, does the same patch need to be applied (Patch 9285774)?Marynoreply@blogger.com