Analysis Services
Menus (Dimension Editor Schema View)
The following options are available through menus in Dimension Editor.
Menu | Option | Description |
---|---|---|
File | New Dimension - Wizard | Starts the Dimension Wizard so you can create a new shared dimension. |
New Dimension - Editor | Displays the Choose a Dimension Table dialog box so you can begin creating a shared dimension with the editor. | |
Save | Saves the dimension. If you are saving a parent-child or changing dimension, you will be prompted to perform an incremental processing of the dimension. | |
Save As | Saves the dimension under a different name. | |
Exit | Closes Dimension Editor. | |
Edit | Rename | Renames the selected object. |
Delete | Deletes the selected object. | |
Remove Join | Removes all joins from the selected column (schema view only). | |
View | Schema | Displays the schema view, including the Schema tab. |
Data | Displays the data view, including the Data tab. | |
Properties | Expands or collapses the properties pane. | |
Insert | Tables | Displays the Select Table dialog box so you can add tables to the dimension. |
Level | Displays the Insert Level dialog box so you can add a new level. | |
Member Property | Displays the Insert Member Property dialog box so you can add a new member property in the selected level. | |
Join | Displays the Join Columns dialog box, where you can add a join to the selected column (schema view only). | |
Tools | Process Dimension | Processes the dimension. |
Count Dimension Members | Counts the number of members in a dimension. | |
Validate Dimension Structure | Verifies that the dimension structure does not contain invalid components that would prevent processing of the dimension. | |
Help | Help on Dimension Editor | Displays a Help topic about Dimension Editor. |
Contents and Index | Opens SQL Server Books Online. |