ClearCache(cubeName) This function clears the cache which is useful when doing performance tuning. If you call ClearCache without any parameters the entire cache for the current database is cleared. If the optional cubeName parameter is specified then only the cache for that particular cube is cleared.
-- Clears the cache for the current database
CALL ASSP.ClearCache();
-- Clears the cache for the Adventure Works cube in the current database
CALL ASSP.ClearCache("Adventure Works");