When you build and deploy the Cube (in Business Intelligence Development Studio, now superseded by SQL Server Data Tools), the next step is to process the Cube.
I ran into an error which went similar to this : “A connection could not be made to the datasource with the DataSourceID of xxxx.”
The problem is well known and simple to resolve. When we first create the Data Source, we must specify the Impersonation option. I had given it as “Inherit”. However, this fails as this cant login to the Analysis Server database.
The solution is to give a more privileged user (depending on your security settings). For me, I could give the Windows login that connects to my SQL Server here. Therefore in the Design View of BIDS, right click your Data Source in Solution Explorer and choose Open. In the “Impersonation Information” tab, pls give the username/password in “Use a specific Windows username and password”. Now rebuild, deploy and process the cube.
I hope this helps. Pls let me know if there are any doubts.