REFRESH CUBE Statement (MDX)

Refreshes the client cache for a cube.


REFRESH CUBECube_Name 

Cube_Name

A valid string expression that provides a cube name.

For client applications connected to an instance of Microsoft SQL Server Analysis Services, this statement causes the memory cached on the client application to be synchronized with the server. While this will ordinarily be detected and updated automatically, the length of time before this happens depends on the client connection string settings. The REFRESH CUBE statement refreshes data immediately.

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

Important noteImportant

Named sets that are stored on the server are not refreshed.

Community Additions

ADD
Show: