Cube Editor - Schema View

Analysis Services

Analysis Services

Cube Editor - Schema View

Use this tool to view and edit the schema of a cube and examine and edit the structure of a cube. You can also use Cube Editor and connected dialog boxes to perform various procedures.

Cube Editor appears in two views, data and schema. Both views include the tree pane and the properties pane, but the data view includes the Data tab, whereas the schema view includes the Schema tab. You can switch from one view to another by clicking the Data tab or the Schema tab at the bottom of Cube Editor. You can also click Data or Schema on the View menu.

This topic describes the schema view. For information about the data view, see Cube Editor - Data View. The schema view is shown here.

Cube Editor appears when you do either of the following:

  • In the Analysis Manager tree pane, right-click a cube, and then click Edit.

  • In the Analysis Manager tree pane, click a cube, and then on the Action menu, click Edit.

Cube Editor has five areas. For more information about the areas, click a link in the following table.

To do this See
Perform commands available in the Cube Editor menus Menus (Cube Editor Schema View)
Perform common actions represented by icons on the Cube Editor toolbar Toolbar (Cube Editor Schema View)
View cube objects displayed in the tree pane Tree Pane (Cube Editor Schema View)
View and modify certain properties of the object selected in the Cube Editor tree pane

View descriptions of properties and the objects to which they apply

Properties Pane (Cube Editor Schema View)
View a the fact table and the dimension tables of a cube, and all columns in a table

Add measures and shared dimensions, and create private dimensions

Schema Tab (Cube Editor Schema View)

See Also

Building a Cube with the Editor

Creating and Maintaining Private Dimensions

Specifying Drillthrough Options