REFRESH CUBE Statement (MDX)

Refreshes the client cache for a cube.

Syntax

REFRESH CUBE Cube_Name 

Arguments

• Cube_Name
  A valid string expression that provides a cube name.

Remarks

For client applications connected to an instance of Microsoft SQL Server 2005 Analysis Services (SSAS), 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

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

See Also

Other Resources

MDX Data Definition Statements (MDX)

Help and Information

Getting SQL Server 2005 Assistance