Analysis Services
Menus (Cube Editor Schema View)
The following options are available through the menus in Cube Editor.
| Menu | Option | Description |
|---|---|---|
| File | New Cube - Wizard | Starts the Cube Wizard so you can create a new cube. |
| New Cube - Editor | Displays the Choose a Fact Table dialog box so you can begin building a cube with the editor. | |
| Save | Saves the cube. 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 cube under a different name. | |
| Exit | Closes Cube Editor. | |
| Edit | Edit | Edits the selected object. This option is unavailable for objects that have no associated editor or wizard. |
| 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 cube. |
| Dimension - New | Starts the Dimension Wizard so you can create a new dimension. | |
| Dimension - Existing | Displays Dimension Manager so you can add existing shared dimensions to the cube. | |
| Level | Displays the Insert Level dialog box so you can add a new level. | |
| Measure | Displays the Insert Measure dialog box so you can add a new measure. | |
| Member Property | Displays the Insert Member Property dialog box so you can add a new member property. | |
| Calculated Member | Displays Calculated Member Builder so you can begin creating calculated members. | |
| Calculated Cells | Displays the Calculated Cells Wizard so you can begin creating calculated cells. | |
| Action | Starts the Action Wizard so you can create a new action. | |
| Named Set | Displays Named Set Builder so you can define a new named set. | |
| Join | Adds a join to the selected column (schema view only). | |
| Tools | Process Cube* | Processes the cube. |
| Design Storage | Starts the Storage Design Wizard so you can select storage options and design aggregations for the cube. | |
| Drillthrough Options* | Displays the Drillthrough Options dialog box so you can select the columns that are displayed when a drillthrough is executed. | |
| Count Dimension Members | Provides an estimate of the number of members in a dimension. This estimate is used by the aggregation design algorithm when it determines what aggregations to create for this dimension. | |
| Validate Cube Structure | Verifies that the cube structure does not contain invalid components that would prevent processing of the cube. | |
| Optimize Schema | Simplifies a cube's schema for maximum performance during processing by removing unnecessary joins between dimension and fact tables and eliminating the need to read dimension tables during processing.
Several conditions must be met before this option can be used. For more information, see Optimizing Cube Schemas. To remove other tabular joins, use the Remove Join command. |
|
| Help | Help on Cube Editor | Displays a Help topic about Cube Editor. |
| Contents and Index | Opens SQL Server Books Online. |
* If this option is not available, the cube structure is not valid. You can try to determine the problem by clicking Validate Cube Structure on the Tools menu.