Invoke-ProcessCube

Conducts the Process operation on a specified Cube of a specific database with a specific ProcessType value.
Invoke-ProcessCube [-Name*] <System.String> [-Database*] <System.String> [-ProcessType*]<Microsoft.AnalysisServices.ProcessType> [<CommonParameters>]
Invoke-ProcessCube -Database*Cube <Microsoft.AnalysisSevices.Cube> [-ProcessType*]<Microsoft.AnalysisServices.ProcessType> [<CommonParameters>]

Conducts the Process operation on a specific Cube of a specific database with a specific ProcessType value depending upon the input values.

Parameters
-Name <System.String>

  • This value is required

Name of the Cube that has to be processed.
-Database <System.String>

  • This value is required

Database name to which the Cube belongs to.
-ProcessType <Microsoft.AnalysisServices.ProcessType>

  • This value is required

Analysis Services ProcessType value.

ProcessFull

ProcessAdd

ProcessUpdate

ProcessIndexes

ProcessData

ProcessDefault

ProcessClear

ProcessStructure

ProcessClearStructureOnly

ProcessScriptCache

ProcessRecalc
-DatabaseCube <Microsoft.AnalysisSevices.Cube>

Microsoft.AnalysisServices.Cube object that has to be processed.
<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,ErrorAction, ErrorVariable, WarningAction, WarningVariable,OutBuffer, PipelineVariable, and OutVariable.

Examples
  1. The above cmdlets retrieves the specified cube object and processes it: 
    PS SQLSERVER:SQLASMachineNameInstanceDatabasesDB1CubesCube1>  Get-Item .| Invoke-ProcessCube -ProcessType:ProcessDefault
  2. The above cmdlet processes the cube myCube available under database Db1: 
    PS SQLSERVER:SQLASMachineNameInstanceDatabasesDB1Cubes>  Invoke-ProcessCube -Name "myCube" -Database "Db1" -ProcessType "ProcessDefault"
Additional Notes

Back to PowerShell Command list