OLAP Connection String Defaults

When connecting to SQL Server Analysis Services, a set of defaults properties are used in the connection string to ensure a desired behaviour.

At present, the defaults are:

Integrated Security=SSPI;Provider=MSOLAP.3;SSPI=NTLM;MDX Compatibility=2;Optimize Response=2;

Injected Properties

When the connections are made, certain other proerties are injected

Application Name

This property is populated by CALUMO with information about what area of CALUMO is calling the given query. It will take the format: CALUMO <area>:<subarea> (<site>)

Data Source

This property is populated with the SQL Server Analysis Services instance that the query needs to be run against

Initial Catalog

This property is populated with the Catalog the query needs to be run against

LocaleIdentifier

This property is populated with SQL Server Locale value that is assigned to a user, if one is assigned.

EffectiveUserName

This property is used when running CALUMO in a multi-tiered environment where SQL Server Analysis Services is not on the same machine as the CALUMO Web Server. It will be populated with the username of the user running the current query so that Analysis Services will impersonate that user to make the query, ensuring the correct security is applied

Reference

For reference, this is the Microsoft Docs page on all the available connection string properties for connections to SQL Server Analysis Services:

https://docs.microsoft.com/en-us/analysis-services/instances/connection-string-properties-analysis-services