[font="Tahoma"]Thanks for the reply. Changing the XMLA or changing it in Production sound like a solution to my problem but if I need to deploy my cube few times a week or month do not you think it really troublesome is changing each Data source details in PROD or in XMLA.

Is it the best way of doing in real life situation ?[/font]