navigate and process Analysis Services by powershell

最新推荐文章于 2020-07-22 18:04:45 发布

dbLenis

最新推荐文章于 2020-07-22 18:04:45 发布

阅读量542

点赞数

CC 4.0 BY-SA版权

分类专栏： SSAS

本文链接：https://blog.youkuaiyun.com/wujiandao/article/details/8373592

SSAS 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一种使用 PowerShell 脚本连接 Microsoft Analysis Services (SSAS) 的方法，并展示了如何获取 SSAS 中的数据库、立方体、维度等详细信息，最后执行了数据库和立方体的全量处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices");
$ASConnectionString = "Data Source = lewis-server ; Initial Catalog = CapitalDW ; Provider = MSOLAP; Impersonation Level = Impersonate " ;
$ASServer = New-object Microsoft.AnalysisServices.Server ;

$ASServer.connect($ASConnectionString);

##get-content Variable::ASConnectionString
##get-content Variable::ASServer
$DatabaseName = "CapitalDW"
$DatabaseID = $ASServer.Databases.FindByName($DatabaseName).ToString() ;
##get-content Variable::DatabaseID;
write-host "Databaseid:$DatabaseID";

##Cube
$dbName = $ASServer.Databases[$DatabaseID];
##get-content Variable::dbName

foreach( $cube in $dbName.cubes)
{
   ##get-childitem Variable::cube;
   write-host "cube name:$($cube.Name) "
   foreach ( $measuregroup in $cube.measuregroups){
       write-host "measuregroup name:$($measuregroup.name)"
           foreach ( $partition in $measuregroup.partitions ){
                   write-host "partition name:$($partition.name)"
                   }
           foreach ( $measuregroupdimenion in $measuregroup.dimensions )
           {
               write-host "measuregroupdimension: $($measuregroupdimension.name) "
           }
   }
   foreach ( $cubedimenion in $cube.dimensions )
   {
       write-host "cubedimension: $($cubedimension.name)";
   }

}

foreach ( $dimension in $dbName.dimensions)
{
   write-host "dimensions: $($dimension.name) "
}

write-host "Dimension Processing..."
foreach ( $dimension in $dbName.dimensions)
{
   write-host "Dimension Processing Now: $($dimension.name) "
   $dimension.process("ProcessFull");
}

write-host "Cube Processing..."
foreach( $cube in $dbName.cubes)
{
   write-host "Cube Processing Now: $($cube.name) "
   $cube.process("ProcessFull");
}