TechNet
Export (0) Print
Expand All

Cube Designer (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

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:

TabDefinition
Cube StructureUse 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 UsageUse 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).
CalculationsUse 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).
KPIsUse 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).
ActionsUse 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).
PartitionsUse 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).
PerspectivesUse 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).
TranslationsUse 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).
BrowserUse this tab to browse data and metadata for the cube. For more information about this tab, see Browser (Cube Designer) (Analysis Services - Multidimensional Data).

Cube Objects (Analysis Services - Multidimensional Data)
Cubes in Multidimensional Models
Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Community Additions

ADD
Show:
© 2016 Microsoft