Invoke-ProcessCube
Realiza la operación Process en un cubo especificado de una base de datos concreta con un valor ProcessType específico.
Syntax
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>]
Description
Realiza la operación Process en un cubo especificado de una base de datos concreta con un valor ProcessType específico, según los valores de entrada.
Module requirements: version 21+ on PowerShell 5.1; version 21 (recent preview) or version 22+ on PowerShell 7.x.
Ejemplos
Procesamiento del cubo desde la canalización
PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1\Cubes\Cube1> Get-Item . | Invoke-ProcessCube -ProcessType:ProcessDefault
Invocación de cubo con el nombre
PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1\Cubes> Invoke-ProcessCube -Name "myCube" -Database "Db1" -ProcessType "ProcessDefault"
Parámetros
-ApplicationId
Identificador de aplicación de la entidad de servicio.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-CertificateThumbprint
Huella digital del certificado para la entidad de servicio.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
Le solicita su confirmación antes de ejecutar el cmdlet.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Credential
Si se especifica este parámetro, el nombre de usuario y la contraseña pasadas se utilizarán para conectarse a la instancia de Analysis Server especificada.
Si no se especifica ninguna credencial, se utilizará la cuenta predeterminada de Windows del usuario que ejecuta la herramienta.
Type: | PSCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Database
Nombre de la base de datos al que pertenece el cubo.
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabaseCube
Objeto Microsoft.AnalysisServices.Cube que se tiene que procesar.
Type: | Cube |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Name
Nombre del cubo que tiene que procesarse.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ProcessType
Valor ProcessType de Analysis Services.
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
Tipo de actualización.
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
Opcionalmente, especifica la instancia del servidor a la que conectarse si no está actualmente en el directorio del proveedor SQLAS.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServicePrincipal
Especifica que esta conexión usa la entidad de servicio.
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TenantId
Identificador de inquilino de la entidad de servicio.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
Muestra lo que sucedería si se ejecutara el cmdlet. El cmdlet no se ejecuta.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Entradas
Microsoft.AnalysisServices.Cube
Notas
No se admite en bases de datos tabulares con el nivel de compatibilidad 1200 o superior.