Invoke-ProcessCube
对特定数据库的具有特定 ProcessType 值的指定多维数据集执行 Process 操作。
语法
Invoke-ProcessCube
[-Name] <String>
[-Database] <String>
[-ProcessType] <ProcessType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Invoke-ProcessCube
-DatabaseCube <Cube>
[-ProcessType] <ProcessType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Invoke-ProcessCube
[-Database] <String>
[-RefreshType] <RefreshType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Invoke-ProcessCube
[-RefreshType] <RefreshType>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] 说明
根据输入值，对特定数据库的具有特定 ProcessType 值的特定多维数据集执行 Process 操作。
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\Cube1> Get-Item . | Invoke-ProcessCube -ProcessType:ProcessDefault使用名称调用多维数据集
PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1\Cubes> Invoke-ProcessCube -Name "myCube" -Database "Db1" -ProcessType "ProcessDefault"参数
-ApplicationId
服务主体的应用程序 ID。
| 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 |
-Database
多维数据集所属的数据库名称。
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DatabaseCube
必须处理的 Microsoft.AnalysisServices.Cube 对象。
| Type: | Cube |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Name
必须处理的多维数据集的名称。
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ProcessType
Analysis Services 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 |
-TenantId
服务主体的租户 ID。
| 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 |
输入
Microsoft.AnalysisServices.Cube
备注
在兼容级别为 1200 或更高的表格数据库上不受支持。