We have been waiting for 11.0.7 for a long time now, but when it finally arrives, we cannot get any SSAS connections to work properly.
Our test environment consist of MS SQL 2016-SP1 (Windows Server 2012 R2) and Cognos Analytics 11.0.7 (Windows Server 2012 R2)
We have installed appropriate 64bit driver (Analysis Services OLE DB Provider for Microsoft SQL Server® 2016).
When testing the datasource we get an error:
XOD-CON-0001 Failed to connect to OLE DB for the provider (Microsoft Analysis Services 2016) and server (cognosdw01). The data provider returned an error message: "The '-1' locale is not supported.".
It seems it is parsing a invalid locale in the connection string:
Connection string:
"^User ID:^
Password:;LOCAL;M16;SERVER=cognosdw01;UID=%s;PWD=%s;LCID=en-us"
As far as I can see the supported locales needs to be 4 digit code (ie 1033).
The SSAS instans is running "danish-norwegian" collation. We have tried with "Latin_1_General". Same result.
Any ideas?