Post reply

Using XMLA to perform batch deletion of olap databases

  • March 24, 2011 at 6:38 pm

    #142450

    Has anyone written a script that will go through all the olap databases and delete them?

    I am looking to delete more than one db at a time.

    I'm assuming one would execute some kind of xmla batch script, but it may not be possible.

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

    <Object>

    <DatabaseID>olap_db</DatabaseID>

    </Object>

    </Delete>

    Thanks,

    Keith Wiggans

  • June 2, 2015 at 6:05 am

    #1802253

    :w00t:

    Ever got XMLA to delete multiple databases?

    4 years later 🙂

  • June 2, 2015 at 6:08 am

    #1802254

    Never figured out how to get it to work. I'm doing my MCSE for business intelligence, so I'm sure I'll figure it out some day.

    Keith Wiggans

  • June 2, 2015 at 7:29 am

    #1802286

    Isn't it just something like:

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

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

    <Object>

    <DatabaseID> OLAPDatabase </DatabaseID>

    <CubeID> Cube 1 </CubeID>

    </Object>

    </Delete>

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

    <Object>

    <DatabaseID> OLAPDatabase </DatabaseID>

    <CubeID> Cube 2 </CubeID>

    </Object>

    </Delete>

    </Batch>

    ?

    I'm on LinkedIn

  • June 23, 2015 at 2:15 pm

    #1807553

    Thanks PB_BI

    That is the syntax!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply