Automating SQL Server Analysis Services cubes and cubes processing
take this approach :
1. create a project ( BI Analysis Services type)
2. build this project and it will create the asdatabase file.
3.Automate cubes deploy : Deploy the asdatabse file with /s options on command line :
command line for it is :
cd C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ && Microsoft.AnalysisServices.Deployment c:\CONDOR_SSAS.asdatabase /s
4. Automate the processing of cube.
deploy the asdatabase file like above without the /s option this will walk you through the wizard to create the XMLA Script.
store these XMLA scripts for your cubes just one time.
5. Automate processing of cubes :
To process one time stored XMLA Scripts the command line is :
cd C:\tools && ascmd.exe -S %COMPUTERNAME% -U %USERDOMAIN%\%USERNAME% -P %NT_PWD% -i "CONDOR_SSAS.xmla"
Note : The ascmd tool used here can be found in SQL Server 2005 Samples.
