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?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.