Invoke-ProcessPartition

Referensi

Modul:: SQLServer

Melakukan operasi Proses pada Partisi tertentu dari database tertentu yang memiliki nama Kubus tertentu dan nama MeasureGroup dengan nilai ProcessType tertentu.

Sintaks

Invoke-ProcessPartition
      [-CubeName] <String>
      [-MeasureGroupName] <String>
      [-Name] <String>
      [-Database] <String>
      [-ProcessType] <ProcessType>
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Invoke-ProcessPartition
      [-PartitionName] <String>
      [-TableName] <String>
      [-Database] <String>
      [-RefreshType] <RefreshType>
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Invoke-ProcessPartition
      -DatabasePartition <Object>
      [-ProcessType] <ProcessType>
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Invoke-ProcessPartition
      -DatabasePartition <Object>
      [-RefreshType] <RefreshType>
      [-Server <String>]
      [-Credential <PSCredential>]
      [-ServicePrincipal]
      [-ApplicationId <String>]
      [-TenantId <String>]
      [-CertificateThumbprint <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Deskripsi

Melakukan operasi Proses pada Partisi tertentu dari database tertentu yang memiliki nama Kubus tertentu dan nama MeasureGroup dengan nilai ProcessType tertentu.

Module requirements: version 21+ on PowerShell 5.1; version 21 (recent preview) or version 22+ on PowerShell 7.x.

Contoh

Memproses partisi dari alur

PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1\Cubes\myCube\MeasureGroups\myMeasureGroup\Partitions\Partition1> Get-Item . | Invoke-ProcessPartition -ProcessType ProcessDefault

Perintah ini disalurkan dalam identitas partisi yang akan diproses.

Proses partisi menggunakan nama

PS SQL SERVER:\SQLAS\MachineName\Instance\Databases\AWTEST\Cubes\Adventure Works\MeasureGroups> Invoke-ProcessPartition �Name "Total_Orders_2003" �MeasureGroupname "Sales Order" �CubeName "Adventure Works" �database "AWTEST" �ProcessType "ProcessFull"

Perintah ini memproses partisi 'Total_Orders_2003' dalam grup ukuran 'Pesanan Penjualan' dari database 'AWTEST'.

Proses partisi metadata tabular

PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1> Invoke-ProcessPartition -PartitionName "myPartition" -TableName "myTable" -Database "DB1"  -RefreshType "Full"

Proses partisi metadata tabular menggunakan jenis refresh enum

PS SQLSERVER:\SQLAS\MachineName\Instance\Databases\DB1> Invoke-ProcessPartition -PartitionName "myPartition" -TableName "myTable" -Database "DB1"  -RefreshType [Microsoft.AnalysisServices.Tabular.RefreshType]::Full

Parameter

-ApplicationId

Id aplikasi untuk perwakilan layanan.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-CertificateThumbprint

Thumbprint sertifikat untuk perwakilan layanan.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Credential

Jika parameter ini ditentukan, nama pengguna dan kata sandi yang diteruskan akan digunakan untuk menyambungkan ke instans Analysis Server tertentu.

Jika tidak ada kredensial yang ditentukan akun windows default pengguna yang menjalankan alat akan digunakan.

Type:	PSCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-CubeName

Nama kubus tempat MeasureGroup berada. (Hanya metadata multidimensi)

Type:	String
Position:	3
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Database

Nama database tempat kubus berada. (Metadata multidimensi dan tabular)

Type:	String
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-DatabasePartition

Objek Microsoft.AnalysisServices.Partition atau Microsoft.AnalysisService.Tabular.Partition yang harus diproses. (Metadata multidimensi dan tabular masing-masing)

Type:	Object
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-MeasureGroupName

Nama MeasureGroup tempat Partisi berada. (Hanya metadata multidimensi)

Type:	String
Position:	4
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Name

Nama Partisi yang harus diproses. (Hanya metadata multidimensi)

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-PartitionName

Nama partisi.

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ProcessType

Menentukan jenis proses (Hanya metadata multidimensi)

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

Jenis refresh.

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

Secara opsional menentukan instans server yang akan disambungkan jika saat ini tidak berada di direktori Penyedia SQLAS.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ServicePrincipal

Menentukan bahwa koneksi ini menggunakan perwakilan layanan.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-TableName

Menentukan nama tabel.

Type:	String
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-TenantId

Id penyewa untuk perwakilan layanan.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

Menunjukkan yang akan terjadi jika cmdlet dijalankan. Cmdlet tidak dijalankan.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Catatan

Didukung pada semua instans Analysis Services

Bagikan melalui