I am new to Hyperion Planning. I have created application then also loaded metadata from CSV file using Outline load utility. Now I have to load huge metadata from DB tables(oracle) to application.
Please let us know the process to load metadata from tables.
Any pointers on this will be helpfull.
Depends on version if it is 184.108.40.206.300+ then have a read of http://john-goodwin.blogspot.co.uk/2012/09/planning-11122300-outline-load-utility.html
Alternatives could be to use ODI.
Thanks John for your help.
I am using version 220.127.116.11. I checked with OutLine Load utility to load metadata from relational tables but it is giving errors (as Unrecognized option:) for parameters - /CP,/RID,etc. I think this is due to version issue.
Is there any other alternative other than ODI to load metadata from relational tables?
Thanks JM for your response.
I tried to use interface tables in EPMA application but somehow I could not load metadata successfully.
Could you please provide detail process to load metadata from interface tables? One more question - when I was trying to load metadata from EPMA interface tables , it was asking for DATASOURCE. Accordingly I provided respective datasource but it didnt ask regarding which table need to be considered for which dimension. I am confused.
John who posted above wrote a great series about how to use interface tables.
The source tables used to load metadata for each dimension are defined in the table IM_Dimension of the database you selected when you initialized the Interface tables.