I had this similar issue and in my case it was caused by a bad aggregation Design in one of the measure group, once the deleted that aggregation design, the...

Although it is hard to tell from the the details you have provided, but it seems like you have some data issue, in the error it says Attribute...

Try using Exec [Sql Statement] At [Server name] it should work e.g.

Exec 'Select * from tablename' At [MyServer]

Regards

Jitender