Cube Designer (SSAS)

Use Cube Designer in Business Intelligence Development Studio 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:

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) (SSAS).

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) (SSAS).

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).

KPIs

Use this tab to create and modify KPIs included in the cube. For more information about this tab, see KPIs (Cube Designer) (SSAS).

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) (SSAS).

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) (SSAS).

Perspectives

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

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) (SSAS).

Browser

Use this tab to browse data and metadata for the cube. For more information about this tab, see Browser (Cube Designer) (SSAS).

Community Additions

ADD
Show: