Measures and Measure Groups - Expert Cube Development with SSAS Multidimensional Models - page 104

This code takes the lowest granularity measure Sales Amount Quota , and then
overwrites it twice: the first assignment replaces all of the values above the Sales
Person granularity with the value of the measure containing Sales Amount Quota
for Team Leaders . The second second assignment then replaces all of the values above
the Team Leader granularity with the value of the measure containing Sales Quotas
for Managers . Once we've set the Visible property to False for the Sales Amount
Quota_TeamLead and Sales Amount Quota_Manager measures, we're left with just
the Sales Amount Quota measure visible, thus displaying the non-aggregatable
values that we wanted. The user would then see the following screenshot:
Using linked dimensions and measure groups
Creating linked dimensions and measure groups allows you to share the same
dimensions and measure groups across separate Analysis Services databases, and the
same measure group across multiple cubes. To do this, all you need to do is to run
the New Linked Object wizard from the Cube Editor either by clicking on the button
in the toolbar on the Cube Structure or Dimension Usage tabs, or by selecting it
from the right-click menu in the Measures pane of the Cube Structure tab.