Wednesday, 31 March 2010  ODI Series - Loading HFM data  In the
last ODI – HFM blog I went through loading metadata into a HFM
application, today I am going to take a quick back to basics
look at loading data into the same application.  In the last
part I loaded 5 new members into the application  Today I am
going to load data into the three bottom level members, the
members aggregate to the next level so I don’t need to bother
loading any data into the higher levels.  I started out with a
basic HFM form that I am going to populate with data, I have
just designed this form for demonstration purposes as I know you
would usually use a form to manually enter data.  In the
designer if you expand your HFM application model you will see a
DataStore called HFMData, this will be used as the target and
contains all the dimensions of the application and a column
DataValue to load the values into.     The overall process is
simple enough :- create your source, in this example is going to
be a flat file, create an interf