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?