Today I am going to look at automating the process using the EPMA batch client and then move on to using ODI to take over control.
Now you don’t have to use ODI as other methods could be used to populate the tables but I am going to use it as it offers such flexibility around transformations and automation in a controlled environment.
At first there was only Smart View available as a standalone installer, no Excel add-in, Financial Reporting Studio, EAS or Essbase Studio console installers were available.
It wasn’t until a patch release in 188.8.131.52 that the Excel add-in was made available as a standalone installer.
I ended up with a set of tables ready to be populated with metadata though I am not going populate them just yet as I think it is worthwhile running through an interface import profile first.
In this part I want to look at interface tables and end up with them built ready to load metadata into.
It is not just a case of updating Smart View as the essbase server and APS need to be patched to 184.108.40.206.102 be able to use this new functionality.
This is probably one of the few posts that I don’t have to spend hours taking screen shots and uploading them.
I have been asked numerous times lately how to delete planning members using ODI, I did cover loading planning metadata way back in one of my early blogs but have never covered deleting and even though it is quite similar to loading metadata I thought I may as well go through the steps and highlight some errors that may be encountered, it also stops me having to repeatedly explain the process and I will be able to be lazy in future and just provide the link to this post.