Dimension Editor - Schema View

Analysis Services

Analysis Services

Dimension Editor - Schema View

Use this tool to view and edit a shared dimension's schema. You can also examine and edit the structure of all types of shared dimensions, including parent-child and virtual dimensions, and their levels. You can also use Dimension Editor and connected dialog boxes to perform various procedures with shared dimensions.

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

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

Dimension Editor appears when you do either of the following:

  • In the Analysis Manager tree pane, under a database, open the Shared Dimensions folder. Right-click a dimension, and then click Edit.

  • In the Analysis Manager tree pane, under a database, open the Shared Dimensions folder. Click a dimension, and then on the Action menu, click Edit.

  • Dimension Editor has four areas. For more information about the areas, click a link in the following table.
    To do this See
    Perform commands available in Dimension Editor menus. Menus
    Perform common actions represented by icons on the Dimension Editor toolbar. Toolbar
    Display objects in the dimension.

    Access associated dialog boxes and available information about dimension objects.

    Tree Pane
    Display the properties of the object selected in the tree pane.

    Modify the property settings for the selected object.

    Properties Pane
    Display the dimension tables.

    Add tables and levels, and browse the data in the dimension tables.

    View columns in a table.

    Schema Tab

See Also

Creating a Shared Dimension with the Editor

Creating Custom Member Formulas

Creating Member Groups

Creating Member Properties