OLAP linked server fails connection test
Enable OLEDB Driver in SQL Server 

EXEC sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;  
GO  
RECONFIGURE;  
GO


If you are still facing the error after running above statement, please post error message