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

MDX Date Range Query

Date Range

WITH SET [MyRange] AS 
'{[Time].[2009].&[5].[22].[26] : [Time].[2009].&[6].[26].[24]}' 
MEMBER [Time].[Range] AS 'Aggregate([MyRange],[Measures].CurrentMember)' 

select {[Measures].[Sends],[Measures].[Views], [Measures].[Clicks]} on columns, 
{[Zone Id].&[142]} 
on rows
from [All Communication Analysis] where ([Time].[Range])