Here is some more information:

I am using Sequel Server Data Tools to do this. As i have previously said i am doing the Analysis Services Tutorials and my impersonation is set to "Use this service account". I am also logged into the local host. I have tried the other settings but with no luck.

This is my local machine. The database was downloaded and i am running a x64 with SQL server 2012 which has the SQL management studio and SQL server tools.

Someone else recommended i try "So in your scenario, to avoid this issue, you can grant the SELECT permission for the default account for AS services to data source DB (Adventure Works DW2012). Or you can change the services account to this domain user who has the corresponding to the data source DB" but i cannot seem to figure how to grant myself access. I do appreciate the responses because i have been stuck on this for a very looong time. Would a screenshot help?