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?

Mark Fry's profile image
Mark Fry IBM Champion posted Wed March 05, 2025 12:43 PM

Hi,

It has been a long (long) time since I connected to Analysis Services from Cognos. I remember there were some specific rules about the format of signons, and I seem to recall the easiest option was to use the credentials of the Cognos service. It looks like it's still an option, but to save listing it all out here, take a look at the documentation anc compare with what you have currently got set up:

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=types-microsoft-analysis-services-data-sources

Cheers!

MF.

Milan Milovanovic's profile image
Milan Milovanovic posted Sun March 09, 2025 01:58 AM

Thanks Fry,

I have to use HTTP XMLA, I can not use domain accounts.
I already saw this web page, but everything on it is talking about domain accounts.
https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=types-microsoft-analysis-services-data-sources

I am thinking that basic authentication is not possible. Cognos is only using domain accounts.

I have tried to connect anonymously to Cognos, but that also failed, with the same error message.
It seems that anonymous access is not possible from the Excel, either.

Related Content