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
----------------------------------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.