< Back
Invoke-ProcessTabularCubeDatabase
Post
NAME Invoke-ProcessTabularCubeDatabase
SYNOPSIS
Processes an SSAS database on a SQL Server SSAS instance
SYNTAX
Invoke-ProcessTabularCubeDatabase [-Server] <String> [-CubeDatabase] <String> [[-RefreshType] <String>]
[<CommonParameters>]
DESCRIPTION
Processes an SSAS database on a SQL Server SSAS instance
PARAMETERS
-Server <String>
Name of the target SSAS server, including instance and port if required.
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CubeDatabase <String>
The name of the tabular cube database on the SSAS server.
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-RefreshType <String>
Valid options are: 'Full', 'Automatic', 'ClearValues', 'Calculate'.
Default value: 'Full'.
'Full': processes all the objects in the cube database. When Full processing is executed against an object
that has already been processed, Analysis Services drops all data in the object and then processes the object.
'Automatic': detects the process state of cube database objects, and performs the processing necessary to
deliver unprocessed or partially processed objects to a fully processed state.
'ClearValues': Clear values in this object and all its dependents.
'Calculate': Recalculate this object and all its dependents, but only if needed. This value does not force
recalculation, except for volatile formulas.
Required? false
Position? 3
Default value Full
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
NOTES
Written by (c) Dr. John Tunnicliffe, 2019 https://github.com/DrJohnT/DeployCube
This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT
RELATED LINKS
https://github.com/DrJohnT/DeployCube
SYNOPSIS
Processes an SSAS database on a SQL Server SSAS instance
SYNTAX
Invoke-ProcessTabularCubeDatabase [-Server] <String> [-CubeDatabase] <String> [[-RefreshType] <String>]
[<CommonParameters>]
DESCRIPTION
Processes an SSAS database on a SQL Server SSAS instance
PARAMETERS
-Server <String>
Name of the target SSAS server, including instance and port if required.
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CubeDatabase <String>
The name of the tabular cube database on the SSAS server.
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-RefreshType <String>
Valid options are: 'Full', 'Automatic', 'ClearValues', 'Calculate'.
Default value: 'Full'.
'Full': processes all the objects in the cube database. When Full processing is executed against an object
that has already been processed, Analysis Services drops all data in the object and then processes the object.
'Automatic': detects the process state of cube database objects, and performs the processing necessary to
deliver unprocessed or partially processed objects to a fully processed state.
'ClearValues': Clear values in this object and all its dependents.
'Calculate': Recalculate this object and all its dependents, but only if needed. This value does not force
recalculation, except for volatile formulas.
Required? false
Position? 3
Default value Full
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
NOTES
Written by (c) Dr. John Tunnicliffe, 2019 https://github.com/DrJohnT/DeployCube
This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT
RELATED LINKS
https://github.com/DrJohnT/DeployCube