Linked Dimensions

SQL Server 2008 R2

In Microsoft SQL Server Analysis Services, a linked dimension is based on a dimension that is stored in another Analysis Services database. The source database for a linked dimension can be on the same server or on a different server. By using a linked dimension, you can create, store, and maintain a dimension on one Analysis Services database, and still make that dimension available to users of multiple databases. To users, a linked dimension appears like any other dimension.


Dimension writeback is not supported for a linked dimension.

Community Additions