You still haven't told anyone what products besides Essbase you are using, without which this is an impossible question to answer.
Are you connecting to these tables from Essbase with a load rule / ODBC? Using Studio? Using Integration Services? Any Drill-Through reporting set up?
This may sound harsh, but if you truly don't know how to answer any of these questions you should probably not be anywhere near this task...
I am confused are yu using Essbase Studio or EIS? If you want to change the datasource for Essbase Studio, there are a few ways to do it. Do make sure the tables/views that you have in your Studio data source are the same. then export the model and data source to XLM, change the connection in the XML file and rei-mport.
I have created Datasource using ODBC and then EIS Console and I have seen using Essbase Studio.As a Entry level person i am just following the doument's to know about these fact table's and Dimesion's.But I got the task like moving the fact table's and dimension's to different server's.So please help on this task to know and from where i should start to complete this task.
Thanks for your update
Frankly, this is a lot to ask for. If you are this new to the tool, you really need to engage a consulting firm that can help you determine the requirement, develop an implemantation plan and help you define the steps. Each companies needs are somewhat unique and will differ.
(as a side note, you should also create new topics when you change subjects)