I am completely new to this FDMEE and i would like to have detailed stpes to load data and metadata from sql to essbase
I would start of taking a look at the Admin guide, its an excellent starting point.
In regards to data - FDMEE contains an Open Interface Adapter (read: table) that you can load into, and then map to a target application. If you want, you can always insert into this open_interface table and from there apply mappings etc. This is outlined in the admin guide.
Metadata is a bit more tricky - as FDMEE anticipates that you are going to be pulling metadata from a source system, like EBS.
Here is a link to the admin guide.
as pointed above:
- SQL DB to Essbase (data): use open interface adapter
- SQL DB to Essbase (metadata): you will have to build a custom solution in FDMEE as open interface adapter only supports data and metadata rules can only pull dimensions from EBS GL and Peoplesoft GL.
from FDMEE you can execute ODI scenarios or other utility to load metadata like outline load utility using scripts