Hier load to Hyperion Planning using ODI Replace

SVK May 15, 2017 5:19 PM

Hi Team,

I have a requirement to load Hier in to Hyperion Planning using ODI and this Hier replaced all the time

it mean, every time when we run a Hier load in to Hyperion Planning it will should be replace but not Merge..

but I did not find any option which will do replace of Hier

ODI Version: 11.1.1

Hyperion Planning Version: 11.2.3

Vijay

1. Re: Hier load to Hyperion Planning using ODI Replace

rpc1 May 15, 2017 7:53 PM (in response to SVK)

I think this article will be useful for you Dynamic Integrations for Multiple Hyperion Planning Applications
If you want to merge dimension elements tree, you have to prepare table with difference between planning dimension and source table.
For example our solution:
1. we created view in the hyperion app database which generates dimension hierarchy with elements and it attributes and properties
2. loaded data from view to the staging database
3. compare elements properties and attributes with the new source
4. insert/update/delete only differs between element lists
Like Show 0 Likes(0)

Actions