How to: Create a Calculated Member
You create a calculated member by using the Calculations view in Cube Designer, which is accessed from Business Intelligence Development Studio. After you create the calculated member, it becomes available to users after you re-deploy the cube.
To create a calculated member
Open the cube for which you want to create a calculated member, and click the Calculations tab.
On the toolbar, click the New Calculated Member button, and then in the expression pane, do the following:
- Under Name, type a name for the calculated member.
- From the Parent hierarchy drop-down list, choose the parent hierarchy.
- From the Parent member drop-down list, choose the parent member, if applicable.
- Under Expression, create a Multidimensional Expressions (MDX) expression to define the calculated member. You can either type the expression manually, or you can drag and drop items from the Metadata and Functions tabs.
Optionally, expand Additional Properties, and then do the following:
- Set the Format string and Visible properties: choose settings from the drop-down lists next to each property name.
- Set the Fore color, Back color, Font name, Font size, and Font flags properties: click the button to the right of each text box, click the setting you want, and then click OK. Alternatively, you can type the values manually.
See Also
Concepts
Defining and Configuring a Calculation
Other Resources
Calculations How-to Topics (Analysis Services)
Defining Calculated Members