Monday, May 5, 2014

Deploying SSAS Cube through Command Line Utility

We can deploy SSAS Cube through Command line utility. I have created a batch file which will auto build the project solution and execute the command through exe

----------------------------------Start---------------------------------------------
ECHO ON
ECHO Build started . . .

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe D:\SSAS\CubeProject\CubeProject.sln/build development /out ssasbuild.log


ECHO Build completed . . .
ECHO XMLA Script generation started

Microsoft.AnalysisServices.Deployment.exe D:\SSAS\CubeProject\CubeProject\bin\CubeProject.asdatabase /d /o:D:\SSAS\CubeProject\CubeProject\cube.xmla

ECHO XMLA Script generation complete . . .
ECHO OFF

PAUSE Completed

-----------------------------------End----------------------------------------------

Reference:  http://technet.microsoft.com/en-us/library/ms162758.aspx

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.