Calculation

Mist User Guide
Calculation Editor

Use the Calculations editor to create and edit calculations, including calculated members, named sets, and MDX script commands.

Calculation Designer

For a Calculated Member, enter its name, parent hiearchy, format string, and other properties in its data grid row.

Calculated Member

Select a MDX expression type and then enter a MDX expression below. Alternatively, most types provide a dropdown for entry, generating MDX automatically.

Calculated Member MDX Expression Editor

For a Named Set, enter its name in the data grid and enter its MDX expression in the large text editor.

Named Set MDX Expression Editor

For a Script Command, enter its name in the data grid and enter its MDX expression in the large text editor.

Script Command MDX Expression Editor

The calculation editor's ribbon provides the following functions:

Calculation Ribbon
ButtonDescription
MDX ScriptAdd a MDX Script to the cube.
Calculated MemberAdd a calculated member to a selected MDX Script.
Named SetAdd a named set to a selected MDX Script.
Script CommandAdd a script command to a selected MDX Script.