How to query SSAS Datasource ConnectionString Properties
0
votes
0
answers
536
views
I've been asked to audit the Connection strings used by our SSAS OLAP cubes and where they are *sourcing data from*.
I can view the properties manually and can even script them:
> Provider=SQLNCLI11.1;Data Source=DEV-SERVER;Integrated
> Security=SSPI;Initial Catalog=EnviroDataMart
But I can't figure out how to query them. Can this be done with SQL or MDX?
Asked by Sir Swears-a-lot
(3253 rep)
Oct 30, 2018, 03:15 AM
Last activity: Oct 30, 2018, 03:49 AM
Last activity: Oct 30, 2018, 03:49 AM