Skip to content

Latest commit

 

History

History
81 lines (50 loc) · 1.99 KB

README.md

File metadata and controls

81 lines (50 loc) · 1.99 KB

ssas-powershell-modules

A single lightweight powershell module with cmdlets to manage SSAS Instances (On-Prem or Azure) Complete samples provided with the modules!

##Install Module from PowerShell Gallery

# In a Admin PowerShell console
Install-Module SSASHelper

Invoke-SSASCommand ...

##(Re)Create Partitions

Invoke-SSASCreatePartition `
    -connectionString $connStr `
    -database "AW Internet Sales Tabular Model" `
    -table "Internet Sales" -partition "Internet Sales 2014" `
    -datasource "Adventure Works DB from SQL" `
    -query $query `
    -verbose

##Process Partition

Invoke-SSASProcessCommand -connectionString $connStr -database "AW Internet Sales Tabular Model" -table "Internet Sales" -partition "Internet Sales 2014" -Verbose

##Process Table

Invoke-SSASProcessCommand -connectionString $connStr -database "AW Internet Sales Tabular Model" -table "Internet Sales" -Verbose

##Process Database

Invoke-SSASProcessCommand -connectionString $connStr -database "AW Internet Sales Tabular Model" -Verbose

##Suspend/Resume Azure AS

Set-AzureASState `
    -resourceGroupName "YourResourceGroup" `
    -serverName "YourServerName" `
	-ApplicationID "YourApplicationId" `
	-ApplicationKey "YourApplicationKey" `
	-tennantid "YourTennantId" `
	-SubscriptionId "YourSubsciptionId" `
	-action "suspend"

Full tutorial on https://devscopebi.wordpress.com/2016/12/14/automate-azure-analysis-services-pauseresume-using-powershell/

Authors

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments