tag:blogger.com,1999:blog-6575283218005807475.post3851303841451439312..comments2023-12-14T05:50:47.097-08:00Comments on More to life...: ODI Series – issue with essbase multi-column data loadsJohn Goodwinhttp://www.blogger.com/profile/03663642245534297566noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6575283218005807475.post-87391531313385710342010-11-01T12:48:56.066-07:002010-11-01T12:48:56.066-07:00Hi Cecile, I think you misunderstood what the blog...Hi Cecile, I think you misunderstood what the blog is about, I know how to use multi column reverse, that is exactly what I do and did in the blog, the issue is how it loads missing cells to essbase.John Goodwinhttps://www.blogger.com/profile/03663642245534297566noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-61923888896083852912010-10-06T08:18:48.202-07:002010-10-06T08:18:48.202-07:00Hi John - first let me indtroduce myself - I am Ce...Hi John - first let me indtroduce myself - I am Cecile working at Oracle Support for ODI<br />Your blog is a great reference to me and I am often looking at it.<br /><br />I wanted to add a comment about multi-column ... there is a way to load data using such file.<br /><br />What is needed is to do a specific reverse.<br /><br />This is a copy-paste from my article 795244.1:<br /><br />---------------------------------<br />First step is to reverse engineer the Essbase Model using ODI RKM Hyperion Essbase with the following options set this way:<br />"MULTIPLE_DATA_COLUMNS" = YES<br />"DATA_COLUMN_DIMENSION" = YOUR_DIMENSION<br />"DATA_COLUMN_MEMBERS" = YOUR_MEMBERS<br /><br />YOUR_DIMENSION is the Name of the Dimension of the Members in your Source File (for example Scenario).<br />YOUR_MEMBERS is the list of the Members in your Source File (for example "actual,budget" )<br /><br />The Datastore created by this reverse engineering for the Data extract / load will contain one column for each of the standard dimensions excluding the dimension specified by DATA_COLUMN_DIMENSION option and as many data columns as specified by the comma separated list for the DATA_COLUMN_MEMBERS option.<br /><br />Once reversed, that Datastore can be used as the Integration Interface target of the multiple data columns source file.<br />----------------------------------<br />I will let you make it easier to understand!!Unknownhttps://www.blogger.com/profile/07629640447160222622noreply@blogger.com