Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 257

Calculated Members
The term calculated member refers to the creation of any MDX object
through a calculation. The calculated member can be part of the Meas-
ures dimension where a simple MDX expression such as addition or sub-
traction of two or more base measures results in a new measure. Such
calculated members on the Measures dimension are referred to as cal-
culated measures. You can also create calculated members on other di-
mensions by specifying an MDX expression. These members are simply
referred to as calculated members. To create a calculated member, click
the Calculations tab of the cube editor. This takes you to the Calculations
view, as shown in Figure 6-25 . The Calculations view contains three win-
dow panes: Script Organizer, Calculation Tools, and Script.
Figure 6-25
The Script Organizer window pane shows the name of the calculation objects of the
cube. Various types of calculations can be created in the Calculations view and one
of them is the calculated member or calculated measure. You can apply a name
to a subset of dimension members that is referred to as named sets. In addition to
calculated members and named sets, you can define a script containing complex
MDX expressions to perform complex business logic calculations. If you right-click
within the Script Organizer you can see the selections to create a calculated mem-
ber, named set, or a script command. These operations can also be performed by