Cube Designer (Analysis Services - Multidimensional Data)

Use Cube Designer in SQL Server Data Tools (SSDT) to edit various properties of an existing cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations, key performance indicators (KPIs), actions, partitions, perspectives, and translations included in the cube, as well as to browse the data contained by the cube. You can display the Cube Designer dialog box by:

  • Right-clicking a cube in Solution Explorer and selecting Open or View Designer from the context menu.

  • Double-clicking a cube in Solution Explorer.

The Cube Designer contains the following tabs:

Tabs

Tab

Definition

Cube Structure

Use this tab to create and modify measure groups and measures, add cube dimensions, and display the objects included in the cube from the associated data source view. For more information about this tab, see Cube Structure (Cube Designer) (Analysis Services - Multidimensional Data).

Dimension Usage

Use this tab to create and modify relationships between cube dimensions and measure groups included in the cube. For more information about this tab, see Dimension Usage (Cube Designer) (Analysis Services - Multidimensional Data).

Calculations

Use this tab to create and modify calculations, including calculated members, named sets, and Multidimensional Expressions (MDX) scripts, included in the cube. For more information about this tab, see Calculations (Cube Designer) (Analysis Services - Multidimensional Data).

KPIs

Use this tab to create and modify KPIs included in the cube. For more information about this tab, see KPIs (Cube Designer) (Analysis Services - Multidimensional Data).

Actions

Use this tab to create and modify actions, including drillthrough actions and report actions, included in the cube. For more information about this tab, see Actions (Cube Designer) (Analysis Services - Multidimensional Data).

Partitions

Use this tab to create and modify partitions, including proactive caching settings for measure groups and partitions, included in the cube. For more information about this tab, see Partitions (Cube Designer) (Analysis Services - Multidimensional Data).

Perspectives

Use this tab to create and modify perspectives included in the cube. For more information about this tab, see Perspectives (Cube Designer) (Analysis Services - Multidimensional Data).

Translations

Use this tab to create and modify translations for measure groups, measures, cube dimensions, perspectives, KPIs, actions, named sets, and calculated members included in the cube. For more information about this tab, see Translations (Cube Designer) (Analysis Services - Multidimensional Data).

Browser

Use this tab to browse data and metadata for the cube. For more information about this tab, see Browser (Cube Designer) (Analysis Services - Multidimensional Data).

See Also

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Concepts

Cube Objects (Analysis Services - Multidimensional Data)

Cubes in Multidimensional Models