Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Microsoft SQL Server Analysis Services provides designers and dialog boxes for use in SQL Server Management Studio and SQL Server Data Tools (SSDT).
Note
To locate the designers and dialog boxes for data mining, see Data Mining Designers and Dialog Boxes.
F1 Help Topics
To help you locate the corresponding topics, the Analysis Services designers and dialog boxes have been divided into the following categories:
Designers
Query Editors
Dialog Boxes
Designers
Topic |
Description |
|---|---|
Use Cube Designer in SQL Server Data Tools (SSDT) to edit the properties of an existing cube, such as the measure groups and measures, cube dimensions and dimension relationships, calculations, key performance indicators (KPIs), actions, partitions, perspectives, and translations included in the cube. You can also use Cube Designer to browse the data contained by the cube. |
|
Data Source View Designer (Analysis Services - Multidimensional Data) |
Use Data Source View Designer in SQL Server Data Tools (SSDT) to edit various properties of a data source view and to organize the objects defined in a data source view in multiple diagrams. |
Database Designer (Analysis Services - Multidimensional Data) |
Use Database Designer in SQL Server Data Tools (SSDT) to edit the properties of and review warnings generated by an Analysis Services database. |
Dimension Designer (Analysis Services - Multidimensional Data) |
Use Dimension Designer in SQL Server Data Tools (SSDT) to edit the properties of an existing dimension. This includes the attributes, hierarchies, levels, and translations of the dimension. You can also use Dimension Designer to browse the data contained by the dimension. |
Use Role Designer in SQL Server Data Tools (SSDT) and SQL Server Management Studio to define or modify a role. |
.gif "Arrow icon used with Back to Top link")
Back to Top
Query Editors
Topic |
Description |
|---|---|
MDX Query Editor (Analysis Services - Multidimensional Data) |
Use the MDX Query Editor to design and execute statements and scripts written in the Multidimensional Expressions (MDX) language. |
XMLA Query Editor (Analysis Services - Multidimensional Data) |
Use the XMLA Query Editor to design and execute statements and scripts written in the XML for Analysis (XMLA) language. |
Back to Top
Dialog Boxes
Topic |
Description |
|---|---|
Add Cube Dimension Dialog Box (Analysis Services - Multidimensional Data) |
Use the Add Cube Dimension dialog box in SQL Server Data Tools (SSDT) to add a reference to a database dimension to a cube. |
Add Reference Dialog Box (Analysis Services - Multidimensional Data) |
Use the Add Reference dialog box in SQL Server Data Tools (SSDT) to add a reference to a .NET assembly or to another project to your development project. |
Add Table Dialog Box (Analysis Services - Multidimensional Data) |
Use the Add Table dialog box in SQL Server Data Tools (SSDT) to add a table when creating a query in the Create Named Query dialog box, Create Polling Query dialog box, or Create Processing Query dialog box. |
Add/Remove Tables Dialog Box (Analysis Services - Multidimensional Data) |
Use the Add/Remove Tables dialog box in SQL Server Data Tools (SSDT) to add or remove tables in a data source to or from a data source view. |
Analysis Server Properties Dialog Box (Analysis Services - Multidimensional Data) |
Use the Analysis Server Properties dialog box in SQL Server Management Studio to set the general, language/collation, and security settings for an Analysis Services instance. |
Assembly Properties Dialog Box (Analysis Services - Multidimensional Data) |
Use the Assembly Properties dialog box in SQL Server Management Studio to set the properties of an assembly reference in an Analysis Services database. |
Assign Aggregation Design Dialog Box (Analysis Services - Multidimensional Data) |
Use the Assign Aggregation Design dialog box in SQL Server Management Studio to assign aggregation designs to one or more partitions. |
Attribute Data Translation Dialog Box (Analysis Services - Multidimensional Data) |
Use the Attribute Data Translation dialog box to set the column that contains the translation caption data, and the collation and sort order to be used with the translated data. |
Backup Database Dialog Box (Analysis Services - Multidimensional Data) |
Use the Backup Database dialog box in SQL Server Management Studio to back up an Analysis Services database to a backup file using the Analysis Services Backup File (.abf) format. |
Browse Data Source Dialog Box (Analysis Services - Multidimensional Data) |
Use the Browse Data Source dialog box in SQL Server Data Tools (SSDT) to view the first 1,000 records of the selected table. |
Browse Data Source View Dialog Box (Analysis Services - Multidimensional Data) |
Use the Browse Data Source View dialog box to view a simple graphical diagram of the selected data source view. The name of the data source view appears as the title of the dialog box. |
Browse for Remote Folder Dialog Box (Analysis Services - Multidimensional Data) |
Use the Browse for Remote Folder dialog box to view a list of the available log and data folders defined for an Analysis Services instance. You can either select a listed folder, or you can specify a different folder if it is required. |
Calculated Member Builder Dialog Box (Analysis Services - Multidimensional Data) |
Use the Calculated Member Builder dialog box in SQL Server Data Tools (SSDT) to add a calculated member. |
Calculation Properties Dialog Box (Analysis Services - Multidimensional Data) |
Use the Calculation Properties dialog box in SQL Server Data Tools (SSDT) to view or edit the properties of calculations defined in the Calculations tab in Cube Designer for the selected cube. |
Change Settings Dialog Box (Analysis Services - Multidimensional Data) |
Use the Change Settings dialog box in SQL Server Data Tools (SSDT) and SQL Server Management Studio to change the settings that govern the processing of objects listed in the Process dialog box. |
Connection Manager Dialog Box (SSAS) |
Use the Connection Manager dialog box in SQL Server Data Tools (SSDT) to define a connection string for a managed .NET or native OLE DB provider. |
Use the Create Attribute Relationship dialog box in SQL Server Data Tools (SSDT) to define new attribute relationships and the Edit Attribute Relationship dialog box to change an attribute relationship. |
|
Create/Edit Named Calculation Dialog Box (Analysis Services) |
Use the Create/Edit Named Calculation dialog box in SQL Server Data Tools (SSDT) to define or modify a named calculation for a table in a data source view. |
Create/Edit Named Query Dialog Box (Analysis Services - Multidimensional Data) |
Use the Create/Edit Named Query dialog box in SQL Server Data Tools (SSDT) to create or edit a named query in Data Source View Designer. A named query can be treated as a table, on which you can base other Analysis Services objects. |
Create/Edit Relationship Dialog Box (Analysis Services - Multidimensional Data) |
Use the Create/Edit Relationship dialog box in SQL Server Data Tools (SSDT) to define or modify a relationship in a data source view. |
Use the Cube Properties dialog box in SQL Server Management Studio to set the properties of a cube in an Analysis Services database. |
|
Data Exploration Options Dialog Box (Analysis Services - Data Mining) |
Use the Data Exploration Options dialog box in SQL Server Data Tools (SSDT) to set the sampling and charting options for the Explore Data dialog box. |
Data Sample Viewer Dialog Box (Analysis Services - Multidimensional Data) |
Use the Data Sample Viewer dialog box in SQL Server Data Tools (SSDT) to view the first 1,000 records of a fact table to be used to provide measures for a new cube. |
Data Source Designer Dialog Box (SSAS) |
Use the Data Source Designer dialog box in SQL Server Data Tools (SSDT) to create or modify a data source. |
Data Source Properties Dialog Box (SSAS) |
Use the Data Source Properties dialog box in SQL Server Management Studio to set the properties of a data source in an Analysis Services database. |
Use the Data Source View Properties dialog box in SQL Server Management Studio to set the properties of a data source view in an Analysis Services database. |
|
Use the Database Properties dialog box in SQL Server Management Studio to set the properties of a database in an Analysis Services database. |
|
Define Relationship Dialog Box (Analysis Services - Multidimensional Data) |
Use the Define Relationship dialog box to define a relationship between a cube dimension and a measure group in Cube Designer. |
Use the Delete Objects dialog to confirm the deletion of objects in an Analysis Services project in SQL Server Data Tools (SSDT). |
|
Dimension Properties Dialog Box (Analysis Services - Multidimensional Data) |
Use the Dimension Properties dialog box in SQL Server Management Studio to set the properties of a dimension in an Analysis Services database. |
Dismiss Warning Dialog Box (Analysis Services - Multidimensional Data) |
Use the Dismiss Warning dialog box in SQL Server Data Tools (SSDT) to dismiss a particular instance of a warning. |
Analysis Services Duplicate Security Role Dialog Box (Analysis Services - Multidimensional Data) |
Use the Duplicate Role dialog box in SQL Server Management Studio to duplicate an existing role in an Analysis Services database. |
Enable/Disable Writeback Dialog Box (Analysis Services - Multidimensional Data) |
Use the Enable/Disable Writeback dialog box to enable or disable writeback for a measure group in a cube. Enabling writeback on a measure group defines a writeback partition and creates a writeback table for that measure group. Disabling writeback on a measure group removes the writeback partition but does not delete the writeback table, to avoid unanticipated data loss. |
Explore Data Dialog Box (SSAS) |
Use the Explore Data dialog box in SQL Server Data Tools (SSDT) to view sampled data for a selected object, such as a table or view. |
Filter Members Dialog Box (Analysis Services - Multidimensional Data) |
Use the Filter Members dialog box in SQL Server Data Tools (SSDT) to filter dimension members by member caption, member name, member unique name, key column value, or value column value for the current level when browsing a dimension on the Browser tab in Dimension Designer. |
Find Table Dialog Box (Analysis Services - Multidimensional Data) |
Use the Find Table dialog box in SQL Server Data Tools (SSDT) to locate a table in the data source view associated with a dimension, cube, or mining structure. |
Generate Named Query Dialog Box (Analysis Services - Multidimensional Data) |
Use the Generate Named Query dialog box in SQL Server Data Tools (SSDT) to create a named query based on a chart series, chart series value, or chart filter selected from the chart displayed in the Pivot Chart tab of the Explore Data dialog box. |
Impact Analysis Dialog Box (Analysis Services - Multidimensional Data) |
Use the Impact Analysis dialog box in SQL Server Data Tools (SSDT) and SQL Server Management Studio to identify and optionally process dependent objects that are affected if the objects listed in the Process dialog box are processed. |
Impersonation Information Dialog Box (SSAS) |
Use the Impersonation Information dialog box to provide information about the security credentials that are used by the Analysis Services object. |
Incremental Update Dialog Box (Analysis Services - Multidimensional Data) |
Use the Incremental Update dialog box in SQL Server Data Tools (SSDT) and SQL Server Management Studio to define the settings that are used when measure groups and partitions are incrementally updated. |
Key Columns Dialog Box (Analysis Services - Multidimensional Data) |
Use the Key Columns dialog box in SQL Server Data Tools (SSDT) to edit the key columns that are associated with an attribute. |
Level Naming Template Dialog Box (Analysis Services - Multidimensional Data) |
Use the Level Naming Template dialog box in SQL Server Data Tools (SSDT) to construct the level naming template for a parent attribute in a dimension. |
Locate Database Files Dialog Box (Analysis Services - Multidimensional Data) |
Usethe Locate Database Files dialog box to view a list of available files in log and data folders defined for an Analysis Services instance. You can either select a listed file, or you can specify a different folder and file if it is required. |
MDX Builder Dialog Box (Analysis Services - Multidimensional Data) |
Use the MDX Builder dialog box in SQL Server Data Tools (SSDT) or SQL Server Management Studio to build a Multidimensional Expressions (MDX) expression. |
Measure Group Bindings Dialog Box (Analysis Services - Multidimensional Data) |
Use the Measure Group Bindings dialog box to create and modify relationships between attributes in a cube dimension and columns in a measure group for a regular dimension relationship, from the Define Relationship dialog box. |
Merge Partition Dialog Box (Analysis Services - Multidimensional Data) |
Use the Merge Partition dialog box in SQL Server Management Studio to merge partitions for a measure group in a cube. |
Use the New Database dialog box in SQL Server Management Studio to create a new, empty Analysis Services database. |
|
New Measure Dialog Box (Analysis Services - Multidimensional Data) |
Use the New Measure dialog box in SQL Server Data Tools (SSDT) to add a new measure to a measure group in Cube Designer. |
Use the New Measure Group dialog box in SQL Server Data Tools (SSDT) to add a new measure group to a cube in Cube Designer. |
|
Use the Object Binding dialog box in SQL Server Data Tools (SSDT) to define bindings between the property of an Analysis Services object and a table or column in a data source view. |
|
Use the Partition Properties dialog box in SQL Server Management Studio to set the properties of a partition for a cube in an Analysis Services database. |
|
Partition Source Dialog Box (Analysis Services - Multidimensional Data) |
Use the Partition Source dialog box in SQL Server Data Tools (SSDT) to specify the source of fact table data for a partition. |
Process Dialog Box (Analysis Services - Multidimensional Data) |
Use the Process dialog box in SQL Server Data Tools (SSDT) and SQL Server Management Studio to process Analysis Services objects. |
Process Progress Dialog Box (Analysis Services - Multidimensional Data) |
Use the Process Progress dialog box in SQL Server Data Tools (SSDT) and SQL Server Management Studio to monitor processing in Analysis Services. |
Use the Refresh Data Source View dialog box in SQL Server Data Tools (SSDT) to accept or cancel the changes that will occur as a result of refreshing the data source view. The dialog box shows the changes that will be made to the data source view as a result of changes made to the underlying data source. Click OK to accept the changes and refresh the data source view, or click Cancel to ignore the changes and leave the data source view unchanged. |
|
Register Database Assembly Dialog Box (Analysis Services - Multidimensional Data) |
Use the Register Server Assembly dialog box in SQL Server Management Studio to set the properties of an assembly reference in an Analysis Services database. |
Relational Objects Dialog Box (Analysis Services - Multidimensional Data) |
Use the Relational Objects dialog box in SQL Server Data Tools (SSDT) to select tables, views, or other objects from a data source on which you want to set proactive caching. |
Remote Partitions - Advanced Settings Dialog Box (Analysis Services - Multidimensional Data) |
Use the Remote Partitions - Advanced Settings dialog box in SQL Server Management Studio to edit advanced settings, such as the connection string of the data source representing the remote Analysis Services database maintaining remote partitions, while restoring remote partitions from a remote backup file to an Analysis Services database by using the Restore Database dialog box. |
Use the Rename Instance dialog box to rename an existing instance of Analysis Services. |
|
Use the Replace Table with Other Table dialog box in SQL Server Data Tools (SSDT) to replace an existing table in a data source view with a table in the underlying data source that is not yet included in the data source view. |
|
Restore Database Dialog Box (Analysis Services - Multidimensional Data) |
Use the Restore Database dialog box in SQL Server Management Studio to restore an Analysis Services database from a backup file that uses the Analysis Services Backup File (.abf) format. |
Save File As Dialog Box (Analysis Services - Multidimensional Data) |
Use the Save File As dialog box to view a list of available files in log and data folders defined for an Analysis Services instance. |
Security Context Dialog Box (Analysis Services - Multidimensional Data) |
Use the Security Context dialog box in SQL Server Data Tools (SSDT) to change the user and role used to examine data or metadata for an Analysis Services object. |
Select Language Dialog Box (Analysis Services - Multidimensional Data) |
Use the Select Language dialog box in SQL Server Data Tools (SSDT) to select a language for a new translation. |
Select Parent Member Dialog Box (Analysis Services - Multidimensional Data) |
Use the Select Parent Member dialog box in SQL Server Data Tools (SSDT) to select a parent member for a calculated member. |
Show Table Dialog Box (Analysis Services - Multidimensional Data) |
Use the Show Table dialog box in SQL Server Data Tools (SSDT) to include tables from the data source view associated with a dimension, cube, or mining structure. |
Storage Options Dialog Box (Analysis Services - Multidimensional Data) |
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. |
Storage Settings Dialog Box (Analysis Services - Multidimensional Data) |
Use the Storage Settings dialog box in SQL Server Data Tools (SSDT) to set the proactive caching, storage, and notification settings for a dimension, cube, measure group, or partition. |
User Selection Dialog Box (Analysis Services - Multidimensional Data) |
Use the User Selection dialog box in SQL Server Management Studio and SQL Server Data Tools (SSDT) to select users on which to filter queries stored in the query log for the Usage-Based Optimization Wizard. |
View Details Dialog Box (Analysis Services - Multidimensional Data) |
Use the View Details dialog box in SQL Server Data Tools (SSDT) and SQL Server Management Studio to view additional details about a message or operation in Analysis Services. |
XMLA Query Editor (Analysis Services - Multidimensional Data) |
Use the XMLA Query Editor to design and execute statements and scripts written in the Multidimensional Expressions (XMLA) language. |
Back to Top
See Also
Reference
Analysis Services Wizards (Multidimensional Data)