Hi Darren,

Is it possible to get the relational Datasource aka, Server and Database of a multidimensional Catalog? I've been fiddling around with Get-ASConnection but am not so sure it was build for that.

Thanks

Reiner

No, get-ASConnection just returns an AMO connection to SSAS.

You can get the details of the relational data sources with something like the following:

$db = get-asdatabase "localhost\sql08" "Adventure Works DW 2008"
$db.datasources | select name, connectionstring