Different Dialog boxes in sql server analysis service

Use the Storage Options dialog box in SQL Server Data Tools (SSDT) to specify custom storage mode, proactive caching, and notification options for dimensions, cubes, measure groups, and partitions. You can display the Storage Options dialog box in SQL Server Data Tools (SSDT) by clicking Options on the Storage Settings dialog box.

For more information about the Storage Settings dialog box

The Storage Options dialog box contains the tabs listed in the following table.

Page	Definition
General	Use the General tab to specify storage and proactive caching settings.
Notifications	Use the Notifications tab to specify the notification method and related settings.

Adding Cube Dialog Box

       Use the Add Cube Dimension dialog box in SQL Server Data Tools (SSDT) to add a reference to a database dimension to a cube. You can display the Add Cube Dimension dialog box by doing one of the following:

• Click Add Cube Dimension in the Toolbar pane on the Cube Structure or Dimension Usage tab in Cube Designer.
• Right-click the Dimensions pane on the Cube Structure tab in Cube Designer and select Add Cube Dimension from the context menu.
• Right-click the Grid pane on the Dimension Usage tab in Cube Designer and select Add Cube Dimension from the context menu.

Note1:

          Each cube dimension can have only one relationship to a measure group. However, you can create more than one cube dimension and add it to the cube, if the database dimension on which the cube dimension is based is related to measure groups through more than one relationship in the data source view.  
         

         Such dimensions are referred to as role-playing dimensions and commonly occur with time dimensions.

Options

Select dimension

Select an existing database dimension to add a cube dimension based on it to the selected cube. Multiple cube dimensions can be defined from the same database dimension.

Adding Table Dialog Box

Use the Add Table dialog box in SQL Server Data Tools (SSDT) to add a table while creating a query in the Create Named Query dialog box, Create Polling Query dialog box, or Create Processing Query dialog box. 

rm	Definition
Tables	Use the Tables tab to display and select a table to add.
Views	Use the Views tab to display and select a view to add.
Functions	Use the Functions tab to display and select a function or stored procedure to add.
Synonyms	Use the Synonyms tab to display and select a synonym to add.
Refresh	Click to reload all of the tabs on the dialog box.
Add	Click to add the currently selected item.

You can display the Add Table dialog box in SQL Server Data Tools (SSDT) by clicking Add Table from the Toolbar pane of the Create Named Query dialog box, Create Polling Query dialog box, or Create Processing Query dialog box.