Dimension-Based MDX Calculations - Microsoft SQL Server 2008 Analysis Services - page 219

1. In BI Dev Studio, open the FoodMart 2008 project.
2. In the Solution Explorer, double-click the Account.dim dimension to open the
dimension editor.
3. Right-click the Accounts attribute (the parent attribute of the Account dimension) in
the Attributes pane, and choose Properties from the contextual menu.
4. In the property pane, select the UnaryOperatorColumn property and set it to the
account.account_rollup column.

If you browse the Account dimension, you will see a hierarchy of members with unary
operators, as shown in Figure 13.1.

FIGURE 13.1 Icons indicating the unary operators appear next to the dimension members.

Now browse the Budget cube that contains the Account dimension, by following these steps:

1. Right-click the Budget cube in the Solution Explorer to open the cube browser, and
choose Browse from the contextual menu.
2. Drag the Amount measure and drop it in the data area of the browser.
3. Drag the Account dimension and drop it in the rows area.
4. Drill down into the Account dimension.