Uncategorized

Clear cube or dimesion cache

<!–Database–> <Batch xmlns = “http://schemas.microsoft.com/analysisservices/2003/engine”> <ClearCache> <Object> <DatabaseID>TestDW</DatabaseID> </Object> </ClearCache> </Batch> <!–Measure group–> <Batch xmlns = “http://schemas.microsoft.com/analysisservices/2003/engine”> <ClearCache> <Object> <DatabaseID>TestDW</DatabaseID> <CubeID>TestCube</CubeID> <MeasureGroupID>Sales</MeasureGroupID> </Object> </ClearCache> </Batch> <!–Dimension–> <Batch xmlns = “http://schemas.microsoft.com/analysisservices/2003/engine”> <ClearCache> <Object> <DatabaseID>TestDW</DatabaseID> <DimensionID>Dim Customer</DimensionID> </Object> </ClearCache> </Batch>

Read more
Uncategorized

Closing SSAS connection

SELECT * FROM $SYSTEM.DISCOVER_COMMANDS GO SELECT * FROM $SYSTEM.DISCOVER_SESSIONS GO SELECT * FROM $SYSTEM.DISCOVER_CONNECTIONS GO <Cancel xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”> <ConnectionID>100</ConnectionID> </Cancel>