| title | Invoke-ProcessCube cmdlet | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/01/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | reference | |
| ms.assetid | b10ba7c1-8f10-4e72-9626-f9285e4341fd | |
| caps.latest.revision | 9 | |
| author | Minewiskan | |
| ms.author | owend | |
| manager | erikre |
Process a cube using a specific processing type variable.
Invoke-ProcessCube [-Name] <System.String> [-Database] <System.String> [-ProcessType] <Microsoft.AnalysisServices.ProcessType> [<CommonParameters>]
Invoke-ProcessCube –DatabaseCube <Microsoft.AnalysisServices.Cube> [-ProcessType] <Microsoft.AnalysisServices.ProcessType> [<CommonParameters>]
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).
Specifies the cube to be processed.
| Required? | true |
| Position? | 0 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
Specifies the database to which the cube belongs.
| Required? | true |
| Position? | 1 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
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 |
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 |
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see About_CommonParameters.
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 |
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.
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.
PowerShell scripting in Analysis Services
Manage Tabular Models Using PowerShell