Clear SSAS cache

Select new XMLA Query in management studio. Right click the cube and go to properties. Make sure you make a note of the cube database id as this can be different than what the cube is named as

Replace the CubeDATABASEID and SUBCUBENAME with the correct values and run the following:

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

<Object>
<DatabaseID>CUBEDATABASEID</DatabaseID>
<CubeID>SUBCUBENAME</CubeID>
</Object>
</ClearCache>