Get-ASDimension for Cubes doesn't work

Jan 24, 2012 at 1:45 PM

Hi Darren,

I'm trying to get the Dimension of both Catalog and Cube. Catalog works fine, but when trying to get the Cube Dims, I'm getting these error messages.

PS C:\> Get-ASDimension Server\Instance "Adventure_Works_DW_2008" "Adventure Works"
Get-ASDimension : The 'Dimension' with 'Name' = 'Adventure Works' doesn't exist in the collection.
At line:1 char:16
+ Get-ASDimension <<<<  Server\Instance "Adventure_Works_DW_2008" "Adventure Works"
    + CategoryInfo          : NotSpecified: (:) [Get-ASDimension], AmoException
    + FullyQualifiedErrorId : Microsoft.AnalysisServices.AmoException,Gosbell.PowerSSAS.Cmdlets.CmdletGetASDimension 

PS C:\> Get-ASDatabase Server\Instance "Adventure_Works_DW_2008" | Get-ASDimension "Adventure Works"
Get-ASDimension : A connection cannot be made. Ensure that the server is running.
At line:1 char:76
+ Get-ASDatabase Server\Instance "Adventure_Works_DW_2008" | Get-ASDimension <<<<  "Adventure Works"
    + CategoryInfo          : NotSpecified: (:) [Get-ASDimension], ConnectionException
    + FullyQualifiedErrorId : Microsoft.AnalysisServices.ConnectionException,Gosbell.PowerSSAS.Cmdlets.CmdletGetASDimension

Thanks lots,


Jan 24, 2012 at 7:35 PM

Hi Reiner,

Yes, there seems to be some issues with the parameter binding or cube dimensions.

The following variants that get a database level dimension object work, but the cube parameter does not appear to be working

get-asdimension "localhost\sql08" "adventure works dw 2008"
get-asdimension "localhost\sql08" "adventure works dw 2008" "product"