When you want to analyse a cube in sharepoint from excel services you need to create a data connection file and publish it to SharePoint, see the following Blog post for a walk through:
One note, it is stated in the above walk through you need to save the file and upload it to the data connection folder, but its easyer to save it to the data connection folder at once.