Analysis Services

Creating Calculated Members in Regular Cubes

To create a calculated member in a regular cube, use Cube Editor and Calculated Member Builder.

To create a calculated member using Calculated Member Builder

Analysis Manager

Analysis Manager

After you add or change a calculated member in a cube, you must process dependent virtual cubes to provide end users continuing access to them. (This processing is much faster than processing the component cubes if the structures of the component cubes have not changed since they were last processed.) When you add or change the calculated member, virtual cube users connected to the server computer are unaffected as long as they remain connected. However, until you process the dependent virtual cubes, end users who connect will be unable to see them.

Note  Calculated members in regular cubes are not visible in the Analysis Manager tree pane. To create and access them, you must first display Cube Editor.