I'm trying to load data into essbase via ODI interface though 'IKM SQL to Hyperion Essbase (Data)' module .
Every time data gets overwritten, how do i accumulate this data while loading. As it's quite difficult for me to sum up the data and then load.
Use a load rule and define to add to existing values in the load rule, the load rule name can be set in the IKM options.
Are you trying to load full data or level 0 members ?? Can you discribe more about issue...
Thanks John, could you provide me a link or any reference to learn creating a load rule.
It would be quite helpful to a learner.
I'm trying to load full data split by product and entity.
Try: Working with Rules Files