This power Shell scripts gives each table processing date on mail . This power Shell Scripts will fetch the data from Azure analysis services and send email to email id with each cube table process date like below :-
Category: AnalysisServices
StartStopProdAAS powershell scripts
StartStopProdAAS ps file have particular time frame to start the server in compare to UAT server.
StartStopAnalysisServices powerShell scripts
This power shell scripts which help to stop or start analysis server based on requirement as this service is a pay as you use. This scripts help to reduce the project and company cost .
Azure Analysis backup Automation
This Blog will help to create backup file for Azure analysis database model. We have used PowerShell to execute Analysis command which help to create backup file for AS model ,Please find the code below :-
Find the last processing date for each table in analysis services model.
As per current scenario ,we need to do manual intervention to find the last processing date for each table .now we have created power shell scripts to find the last processing date for each table for the cube for analysis server . In Analysis Services, only the last process date for SSAS database are stored […]