REFRESH CUBE Statement

Analysis Services Programming

Analysis Services Programming

REFRESH CUBE Statement

This statement refreshes the client cache for a cube.

BNF

<refresh-cube-statement> ::= REFRESH CUBE <cube-name>

Remarks

For client applications connected to the Analysis server, this statement causes the memory cached on the client application to be synchronized with the server.

For client applications connected to a local cube, the REFRESH CUBE statement causes the local cube file to be rebuilt.

Example

The following example refreshes the client cache that pertains to a cube called [Sales]:

REFRESH CUBE [Sales]