Invoke-ProcessPartition
用特定 ProcessType 值在具有特定 Cube 名稱以及 MeasureGroup 名稱之特定資料庫的特定資料分割上進行處理作業。
Syntax
Invoke-ProcessPartition
[-CubeName] <String>
[-MeasureGroupName] <String>
[-Name] <String>
[-Database] <String>
[-ProcessType] <ProcessType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Invoke-ProcessPartition
[-PartitionName] <String>
[-TableName] <String>
[-Database] <String>
[-RefreshType] <RefreshType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Invoke-ProcessPartition
-DatabasePartition <Object>
[-ProcessType] <ProcessType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Invoke-ProcessPartition
-DatabasePartition <Object>
[-RefreshType] <RefreshType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
用特定 ProcessType 值在具有特定 Cube 名稱以及 MeasureGroup 名稱之特定資料庫的特定資料分割上進行處理作業。
Module requirements: version 21+ on PowerShell 5.1; version 21 (recent preview) or version 22+ on PowerShell 7.x.
範例
從管線處理分割區
PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1\Cubes\myCube\MeasureGroups\myMeasureGroup\Partitions\Partition1> Get-Item . | Invoke-ProcessPartition -ProcessType ProcessDefault
此命令會使用管道傳送要處理之資料分割的識別。
使用名稱處理分割區
PS SQL SERVER:\SQLAS\MachineName\Instance\Databases\AWTEST\Cubes\Adventure Works\MeasureGroups> Invoke-ProcessPartition �Name "Total_Orders_2003" �MeasureGroupname "Sales Order" �CubeName "Adventure Works" �database "AWTEST" �ProcessType "ProcessFull"
此命令會在 'AWTEST' 資料庫的 'Sales Orders' 量值群組中處理分割區 'Total_Orders_2003'。
處理表格式中繼資料分割
PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1> Invoke-ProcessPartition -PartitionName "myPartition" -TableName "myTable" -Database "DB1" -RefreshType "Full"
使用列舉重新整理類型處理表格式中繼資料分割
PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1> Invoke-ProcessPartition -PartitionName "myPartition" -TableName "myTable" -Database "DB1" -RefreshType [Microsoft.AnalysisServices.Tabular.RefreshType]::Full
參數
-ApplicationId
服務主體的應用程式識別碼。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-CertificateThumbprint
服務主體的憑證指紋。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
在執行 Cmdlet 前提示您確認。
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Credential
如果指定了此參數,傳遞的使用者名稱和密碼將會用來連接到指定的 Analysis Server 執行個體。
如果沒有指定認證,則會使用執行此工具之使用者的預設 Windows 帳戶。
Type: | PSCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-CubeName
MeasureGroup 所屬的 Cube 名稱。 僅) (多維度中繼資料
Type: | String |
Position: | 3 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Database
Cube 所屬的資料庫名稱。 (多維度和表格式中繼資料)
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabasePartition
必須處理的 Microsoft.AnalysisServices.Partition 或 Microsoft.AnalysisService.Tabular.Partition 物件。 (多維度和表格式中繼資料分別)
Type: | Object |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-MeasureGroupName
分割區所屬的 MeasureGroup 名稱。 (多維度中繼資料僅)
Type: | String |
Position: | 4 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
必須處理的資料分割名稱。 僅) (多維度中繼資料
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-PartitionName
資料分割的名稱。
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ProcessType
只指定多維度中繼資料 (進程類型)
Type: | ProcessType |
Accepted values: | ProcessFull, ProcessAdd, ProcessUpdate, ProcessIndexes, ProcessData, ProcessDefault, ProcessClear, ProcessStructure, ProcessClearStructureOnly, ProcessScriptCache, ProcessRecalc, ProcessDefrag |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-RefreshType
重新整理的類型。
Type: | RefreshType |
Accepted values: | Full, ClearValues, Calculate, DataOnly, Automatic, Add, Defragment |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Server
選擇性地指定要在 SQLAS 提供者目錄中目前未連線的伺服器實例。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServicePrincipal
指定此連線使用服務主體。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TableName
指定資料表的名稱。
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TenantId
服務主體的租使用者識別碼。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
顯示執行 Cmdlet 後會發生的情況。 Cmdlet 並不會執行。
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
備註
所有 Analysis Services 實例都支援