Did you have a look at Cuberware already? As i mentioned before you can do all medelling tasks necessary including manual creation of dimension elements and also moving them via...
Have a Look at cubeware.de! With 'importer' you can easily Transfer Data from One Database (olap and relational) to the other and do all modelling Tasks related with you cubes!