Schema Tab (Dimension Editor Schema View)

Analysis Services

Analysis Services

Schema Tab (Dimension Editor Schema View)

Use the Schema tab to display the dimension tables. Joins are indicated by lines connecting the key columns between the tables.

In the Schema tab, you can organize the structure of the dimension in a graphical display, add additional tables and levels, and browse the data in the dimension tables.

To view all columns in a table, lengthen the table window vertically, or use the scroll bars. You can also widen the table window to view long column names.

Note  Changing the structure of a dimension causes the results of previous dimension processing to be invalidated. After the structure of a dimension has changed, you must process the dimension to re-create the data.

Working in the Schema Tab

This section lists the actions that can be performed in the Schema tab. Many actions can be performed in multiple ways. For example, an action can be accomplished by a drag-and-drop procedure, or by right-clicking an object, and then clicking an item on the shortcut menu.

To add a new table

  • Right-click anywhere in the Schema tab, and then click Insert Tables.

To remove a table

  • Right-click the title bar of a table, and then click Remove.

To replace a table

  • Right-click the title bar of the table, and then click Replace.

To browse the data in a table

  • Right-click the title bar of a table, and then click Browse Data.

To create a join between two tables

  • Select the key column name in the first table, and then drag it over the corresponding key column name in the second table.

To remove a join between two tables

  • Right-click the line depicting the join, and then click Remove.

To change the alias of a table

  • Right-click the title bar of the table, and then click Change Alias.