Something More....

Disclaimer: The steps mentioned in this post are a workaround and in no scenario intend to replace standard steps of migration published in Oracle documentation. Please take necessary backup before following these steps. These steps may help  to import artifacts when we do not have configured environment from 11.1.1 release to follow upgrade path. I wanted to setup a Hyperion Planning 11.1.2.3 environment to try out new features under this release and thought of creating an application from the extract files of one of my app which I had used long back for training and proof of concept. I created a new Planning app shell similar to the app I was about to import. Since 11.1.2.3 LCM offers ability to upload the LCM extract from shared services console in to File System directory ( import_export by default) , I followed these steps to upload the LCM extract. On trying to open the app under the File System, it did not display any of the artifacts in the detail pane. I...

It has been a long time that I posted anything , and thought of writing something I have been working with lately – ODI. Recently, I was training few newbies in ODI when I was asked a question – “How can we be sure whether we have developed an interface which is an efficient one? “ I guess there is no standard answer to this question. It all depends on the technology we are working with and the transformation we intend to achieve. We need to remember that ODI utilizes the underlying technology to perform its transformation and as a developer we need to make use of it in the best way. In the following post, I will be talking about the process of analyzing our data sources and technology to improve integration process. Let’s consider following scenario and data sources: Flat  File called Products.txt which stores information about product codes Staging DB which stores a Translation table. This table has the Alias names for all the product codes which should be popu...