• Hello James,

    We've done this in the past but now call an SSIS package that controls the processing.

    For the command line processing we called a .xmla file with the following syntax.

    "E:\Utilities\ascmd.exe" -i "E:\XMLA Queries\Portal\Process Dims.xmla" -S "<ServerName>"

    The contents of the Process Dims.xmla would be something like:

    <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

    <Parallel>

    <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

    <Object>

    <DatabaseID>Adventure Works DW 2008</DatabaseID>

    <DimensionID>Dim Customer</DimensionID>

    </Object>

    <Type>ProcessFull</Type>

    </Process>

    <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

    <Object>

    <DatabaseID>Adventure Works DW 2008</DatabaseID>

    <DimensionID>Dim Product</DimensionID>

    </Object>

    <Type>ProcessFull</Type>

    </Process>

    </Parallel>

    </Batch>

    Hope this helps.

    Marc

    Marc BeacomManaging Partner DatalereTAP the Power of Data(tm)