In actually I didn't. What I did was I ran the create table and insert statement scripts on the database engine side and ran the cube create (xmla file) on the analysis side. Then I needed to redirect the datasource to my server. I then re-processed the cube and everything was fine.

Please let me know if you need anything else.