Advanced Dimension Design - Professional SQL Server Analysis Services 2005 with MDX - page 334

Figure 8-12
3. The next step is to ensure that you have set the unary operators cor-
rectly and the rollup to parent occurs as desired. For verification, edit
the Adventure Works DW cube and click the Browser tab. Drag and
drop the Amount measure and the parent-child hierarchy Accounts
from the Metadata pane to the data and row area within the Cube
Browser, and then expand the levels Net Income → Operating
Profit → Gross Margin. Before specifying the unary operator, Analysis
Services aggregates the values for Net Sales and Total Cost of Sales
as a sum to calculate the value for Gross Margin. Because a unary
operator has been specified, you should see the value for Gross