Share via

Automating SQL Server Analysis Services cubes and cubes processing

  • Article

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.