tag:blogger.com,1999:blog-6575283218005807475.post4095628629250510796..comments2023-12-14T05:50:47.097-08:00Comments on More to life...: ODI Series - Essbase to PlanningJohn Goodwinhttp://www.blogger.com/profile/03663642245534297566noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6575283218005807475.post-30459271096256579842011-10-17T07:18:29.504-07:002011-10-17T07:18:29.504-07:00You saved me! Thanks. :)You saved me! Thanks. :)Marcohttp://www.assicurazioni-online-subito.itnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-39437855274688834172011-02-25T01:46:19.033-08:002011-02-25T01:46:19.033-08:00John,
Thank you for this blog.
It's better th...John,<br /><br />Thank you for this blog.<br />It's better than Oracle Forumlucahttp://www.assicura-online.itnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-19154065401461238482009-03-03T01:57:00.000-08:002009-03-03T01:57:00.000-08:00John, thanks for information.But i have some troub...John, thanks for information.<BR/>But i have some trouble in loading full dimension Account.<BR/>In log i see the next <BR/>2009-03-03 11:55:53,937 INFO [DwgCmdExecutionThread]: ODI Hyperion Essbase Adapter Version 9.3.1.1<BR/>2009-03-03 11:55:53,937 INFO [DwgCmdExecutionThread]: Connecting to Essbase application [hyp150] on [10.100.150.17]:[1423] using username [asadmin].<BR/>2009-03-03 11:55:53,953 INFO [DwgCmdExecutionThread]: Successfully connected to the Essbase application.<BR/>2009-03-03 11:55:53,953 INFO [DwgCmdExecutionThread]: Essbase Metadata extract LKM option MEMBER_FILTER_CRITERIA = IDESCENDANTS<BR/>2009-03-03 11:55:53,953 INFO [DwgCmdExecutionThread]: Essbase Metadata extract LKM option MEMBER_FILTER_VALUE = Account<BR/>2009-03-03 11:55:53,953 INFO [DwgCmdExecutionThread]: Essbase Metadata extract LKM option DIMENSION = Account<BR/>2009-03-03 11:55:54,015 INFO [DwgCmdExecutionThread]: Executing essbase member selection to fetch the metadata<BR/>2009-03-03 11:55:54,218 INFO [DwgCmdExecutionThread]: Total number of metadata records fetched from essbase : [1089].<BR/>2009-03-03 11:55:54,218 DEBUG [DwgCmdExecutionThread]: Constructing iterator for the extracted data<BR/>2009-03-03 11:55:54,234 INFO [DwgCmdExecutionThread]: Loading the staging area with the extracted records<BR/>2009-03-03 11:55:54,265 INFO [DwgCmdExecutionThread]: Logging out and disconnecting from the essbase application.<BR/><BR/>But in temporary table neither inserts were didAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-57336049660111204562009-02-12T08:29:00.000-08:002009-02-12T08:29:00.000-08:00John,Thanks for sharing your knowledge and insight...John,<BR/><BR/>Thanks for sharing your knowledge and insight.<BR/><BR/>One question regarding this post...Why would you not just create an interface with the Essbase Cube as the Source and the Planning Application as the Target and use the Sunopsis Memory Engine as the Staging?Wayne D. Van Sluyshttps://www.blogger.com/profile/17449960479582937248noreply@blogger.com