0

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?

2

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.