Invoke-ProcessCube cmdlet
Process a cube using a specific processing type variable.
Syntax
Invoke-ProcessCube [-Name] <System.String> [-Database] <System.String> [-ProcessType] <Microsoft.AnalysisServices.ProcessType> [<CommonParameters>]
Invoke-ProcessCube –DatabaseCube <Microsoft.AnalysisServices.Cube> [-ProcessType] <Microsoft.AnalysisServices.ProcessType> [<CommonParameters>]
Description
The Invoke-ProcessCube cmdlet processes a cube to the level you specify. For example, ProcessFull overwrites existing data with all new data. When processing a cube, you must specify the processing type. For more information, see Processing Options and Settings (Analysis Services).
Parameters
-Name <string>
Specifies the cube to be processed.
Required? |
true |
Position? |
0 |
Default value |
|
Accept pipeline input? |
false |
Accept wildcard characters? |
false |
-Database <string>
Specifies the database to which the cube belongs.
Required? |
true |
Position? |
1 |
Default value |
|
Accept pipeline input? |
false |
Accept wildcard characters? |
false |
-ProcessType <Microsoft.AnalysisServices.ProcessType>
Specifies the process type: ProcessFull, ProcessAdd, ProcessUpdate, ProcessIndexes, ProcessData, ProcessDefault, ProcessClear, ProcessStructure, ProcessCelarStructureOnly, ProcessScriptCache, ProcessRecalc.
Required? |
true |
Position? |
2 |
Default value |
|
Accept pipeline input? |
false |
Accept wildcard characters? |
false |
-DatabaseCube <Microsoft.AnalysisSevices.Cube>
Specifies a Microsoft.AnalysisServices.Cube object to be processed. Use this parameter if you want to pass in the cube name via pipeline.
Required? |
true |
Position? |
named |
Default value |
|
Accept pipeline input? |
True (ByPropertyName) |
Accept wildcard characters? |
false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see About_CommonParameters.
Inputs and Outputs
The input type is the type of the objects that you can pipe to the cmdlet. The return type is the type of the objects that the cmdlet returns.
Inputs |
None |
Outputs |
None |
Example 1
PS SQL SERVER:\sqlas\locahost\default\Databases\AWTEST\Cubes\Adventure Works > Get-Item .| Invoke-ProcessCube–ProcessType:ProcessDefault
This command pipes in the identity of the cube to be processed.
Example 2
PS SQL SERVER:\sqlas\locahost\default > Invoke-ProcessCube “Adventure Works” –database AWTEST –ProcessType:ProcessDefault
This command processes the Adventure Works cube in the AWTEST database.