Cognos Analytics

 View Only

 How to connect Cognos and Multidimensional SSAS via HTTP XMLA using basic authentication?

Milan Milovanovic's profile image
Milan Milovanovic posted Mon February 24, 2025 03:57 PM

I'm trying to connect from Cognos to a multidimensional SSAS database. Connection is over the internet. I'm using HTTP XMLA with basic authentication.

I can connect from Excel or Power BI desktop, but I can't connect from Cognos. I get the error "XQE-DS-0006 Unable to log in to data source".

I tried to connect from the administrator's console:

I also tried to connect from the Data Server Connections:

The file MSOLAP.dll exists on the Cognos server, but it is NOT the correct version. As I understand it, this file is not used for HTTP XMLA connection, so it should not matter.  I am not authorized to change anything on the Cognos server, but I can ask my colleague to make changes.

What should I change to make my connection work?