Dela via


Analysis Services Designers and Dialog Boxes (Analysis Services - Multidimensional Data)

Microsoft SQL Server Analysis Services provides designers and dialog boxes for use in SQL Server Management Studio and Business Intelligence Development Studio.

Note

To locate the designers and dialog boxes for data mining, see Analysis Services Designers and Dialog Boxes (Analysis Services - Data Mining).

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

Cube Designer (Analysis Services - Multidimensional Data)

Use Cube Designer in Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio to edit the properties of and review warnings generated by an Analysis Services database.

Dimension Designer (Analysis Services - Multidimensional Data)

Use Dimension Designer in Business Intelligence Development Studio 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.

Role Designer (Analysis Services - Multidimensional Data)

Use Role Designer in Business Intelligence Development Studio and SQL Server Management Studio to define or modify a role.

Arrow icon used with Back to Top linkBack 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.

Arrow icon used with Back to Top linkBack to Top

Dialog Boxes

Topic

Description

Add Cube Dimension Dialog Box (Analysis Services - Multidimensional Data)

Use the Add Cube Dimension dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio to add a calculated member.

Calculation Properties Dialog Box (Analysis Services - Multidimensional Data)

Use the Calculation Properties dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 (Analysis Services - Multidimensional Data)

Use the Connection Manager dialog box in Business Intelligence Development Studio to define a connection string for a managed .NET or native OLE DB provider.

Create Attribute Relationship and Edit Attribute Relationship Dialog Boxes (Attribute Relationship Designer Tab, Dimension Designer) (Analysis Services - Multidimensional Data)

Use the Create Attribute Relationship dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio to define or modify a relationship in a data source view.

Cube Properties Dialog Box (Analysis Services - Multidimensional Data)

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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 (Analysis Services)

Use the Data Source Designer dialog box in Business Intelligence Development Studio to create or modify a data source.

Data Source Properties Dialog Box (Analysis Services - Multidimensional Data)

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.

Data Source View Properties Dialog Box (Analysis Services - Multidimensional Data)

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.

Database Properties Dialog Box (Analysis Services - Multidimensional Data)

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.

Delete objects and files Dialog Box (Analysis Services)

Use the Delete Objects dialog to confirm the deletion of objects in an Analysis Services project in Business Intelligence Development Studio.

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 Business Intelligence Development Studio 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 (Analysis Services - Multidimensional Data)

Use the Explore Data dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 (Analysis Services - Multidimensional Data)

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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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.

New Database Dialog Box (Analysis Services)

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 Business Intelligence Development Studio to add a new measure to a measure group in Cube Designer.

New Measure Group Dialog Box (Cube Designer)

Use the New Measure Group dialog box in Business Intelligence Development Studio to add a new measure group to a cube in Cube Designer.

Object Binding Dialog Box

Use the Object Binding dialog box in Business Intelligence Development Studio to define bindings between the property of an Analysis Services object and a table or column in a data source view.

Partition Properties Dialog Box (SSMS)

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 Business Intelligence Development Studio to specify the source of fact table data for a partition.

Process Dialog Box (Analysis Services - Multidimensional Data)

Use the Process dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio and SQL Server Management Studio to monitor processing in Analysis Services.

Refresh Data Source View Dialog Box

Use the Refresh Data Source View dialog box in Business Intelligence Development Studio 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 Server 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 Business Intelligence Development Studio 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.

Rename Instance Dialog Box (Analysis Services)

Use the Rename Instance dialog box to rename an existing instance of Analysis Services.

Replace Table with Other Table Dialog Box

Use the Replace Table with Other Table dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio to select a parent member for a calculated member.

Show Table Dialog Box (Analysis Services - Multidimensional Data)

Use the Show Table dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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 Business Intelligence Development Studio 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.

Arrow icon used with Back to Top linkBack to Top