While validating the roles assigned for the TfsReports account, the TfsWarehouseDataReader database role membership was enabled for the TfsWarehouse relational databse.

so everything appeared to be normal, but the error above appeared to be very logical. This made me to check the service account for SQL analysis service; it was running with “NT Authority\Network Service”.