I believe it's because you're trying to apply a method to a property.  This should work

$instances = @('Server1\Instance1','Server1\Instance2')

$instances |
  ForEach-Object {Get-ChildItem...

You could set up an Operator on the SQL Agent with the appropriate email(s) / distribution list that is notified when the job completes successfully.

I'm not too familiar with tabular but your best bet it to split the columns you want to be dimensions into another "table."  The easiest way would be to create...

I stopped using them once I read that they were unreliable for determining the schema of an object.

I thought my dev and test instances on the same machine sharing 4 GB RAM was bad, then I found out the production server has only 6 GB of memory.

Are you using SSAS multidimensional (cubes) or SSAS tabular?  They're two different applications and are designed differently.

You mention DSV which makes me think you have a multidimensional instance,...