CLEAR CACHE - SSAS:
<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>DATABASE</DatabaseID>
</Object>
</ClearCache>
UPDATE IN SSAS:
--BEGIN TRANSACTION
UPDATE CUBE [Adventure Works]
SET ([Date].[Calendar].[Calendar Quarter].&[2003]&[1]
,[Employee].[Employees].&[284]
,[Sales Territory].[Sales Territory].[Country].&[Canada]
,[Measures].[Sales Amount Quota] ) = 7704
--COMMIT TRANSACTION
/*
SELECT ([Date].[Calendar].[Calendar Quarter].&[2003]&[1]
,[Employee].[Employees].&[284]
,[Sales Territory].[Sales Territory].[Country].&[Canada]
,[Measures].[Sales Amount Quota]) on 0
FROM [Adventure Works]
*/
