This documentation is archived and is not being maintained.

Analysis Services Designers and Dialog Boxes (SSAS)

Microsoft SQL Server 2005 Analysis Services (SSAS) provides designers and dialog boxes for use in SQL Server Management Studio and Business Intelligence Development Studio. The following table describes the designers and dialog boxes that are available.

Topic Description

Add Cube Dimension Dialog Box (SSAS)

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 (SSAS)

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 (SSAS)

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

Add/Remove Tables Dialog Box (SSAS)

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 (SSAS)

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 (SSAS)

Use the Assembly Properties dialog box in SQL Server Management Studio to set the properties of an assembly reference in an Analysis Services database.

Attribute Data Translation Dialog Box (SSAS)

Use the Attribute Data Translation dialog box to set the column that contains the translation caption data, as well as the collation and sort order to be used with the translated data.

Backup Database Dialog Box (SSAS)

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 (SSAS)

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 (SSAS)

The Browse Data Source View dialog box displays 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 (SSAS)

The Browse for Remote Folder dialog box displays a list of 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 needed.

Calculation Properties Dialog Box (Analysis Services)

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 (SSAS)

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 (SSAS)

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.

Copy Aggregation Design Dialog Box (SSAS)

Use the Copy Aggregation Design dialog box in SQL Server Management Studio to copy the aggregation design from a source partition to one or more destination partitions.

Create Polling Query Dialog Box (SSAS)

Use the Create Polling Query dialog box in Business Intelligence Development Studio to create a polling query in the Notifications tab of the Storage Options dialog box. A polling query is typically a singleton query that returns a value that Analysis Services can use to determine if changes have been made to a table or other relational object.

Create Processing Query Dialog Box (SSAS)

Use the Create Processing Query dialog box in Business Intelligence Development Studio to create a processing query on the Notifications tab of the Storage Options dialog box. A processing query is a query that returns a rowset containing the changes made to a table associated with an Analysis Services object since the last time the table was polled to incrementally update the MOLAP cache for the object. Processing queries are not necessary when fully updating the MOLAP cache for the object.

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 (SSAS)

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 (SSAS)

Use the Create/Edit Relationship dialog box in Business Intelligence Development Studio to define or modify a relationship in a data source view.

Cube Designer (SSAS)

Use Cube Designer in Business Intelligence Development Studio to edit various properties of an existing cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations, key performance indicators (KPIs), actions, partitions, perspectives, and translations included in the cube, as well as to browse the data contained by the cube.

Cube Properties Dialog Box (SSAS)

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 (SSAS)

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 Mining Model Designer (SSAS)

This section contains the F1 Help topics for Data Mining Designer in Business Intelligence Development Studio. Use this design space to create, manage, and work with data mining models.

Data Sample Viewer Dialog Box (SSAS)

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 (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.

Data Source View Designer (SSAS)

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.

Data Source View Properties Dialog Box (SSAS)

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 Designer (SSAS)

Use Database Designer in Business Intelligence Development Studio to edit the properties of an Analysis Services database.

Database Properties Dialog Box (SSAS)

Use the Database Properties dialog box in SQL Server Management Studio to set the properties of a database in an Analysis Services database.

DataItem Collection Editor Dialog Box (SSAS)

Use the DataItem Collection Editor dialog box in Business Intelligence Development Studio to edit the collection of data items associated with the property of an Analysis Services object.

Define Relationship Dialog Box (Analysis Services)

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 within an Analysis Services project in Business Intelligence Development Studio.

Dimension Designer (SSAS)

Use Dimension Designer in Business Intelligence Development Studio to edit various properties of an existing dimension, including the attributes, hierarchies, levels, and translations of the dimension, as well as to browse the data contained by the dimension.

Dimension Properties Dialog Box (SSAS)

Use the Dimension Properties dialog box in SQL Server Management Studio to set the properties of a dimension in an Analysis Services database.

DMX Query Editor (SSAS)

Use the DMX Query Editor to design and execute statements written in the Data Mining Extensions (DMX) language.

Analysis Services Duplicate Security Role Dialog Box (SSAS)

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 (SSAS)

The Enable/Disable Writeback dialog box enables or disables 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 Business Intelligence Development Studio to view sampled data for a selected object, such as a table or view.

Filter Members Dialog Box (SSAS)

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 while browsing a dimension on the Browser tab in Dimension Designer.

Find Table Dialog Box (SSAS)

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 (SSAS)

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 (SSAS)

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 (SSAS)

Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object.

Incremental Update Dialog Box (SSAS)

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.

Level Naming Template Dialog Box (SSAS)

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 (SSAS)

The Locate Database Files dialog box displays 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 needed.

MDX Builder Dialog Box (SSAS)

Use the MDX Builder dialog box in Business Intelligence Development Studio or SQL Server Management Studio to build a Multidimensional Expressions (MDX) expression.

MDX Query Editor (SSAS)

Use the MDX Query Editor to design and execute statements and scripts written in the Multidimensional Expressions (MDX) language.

Measure Group Bindings Dialog Box (SSAS)

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.

Mining Model Properties Dialog Box (SSAS)

Use the Mining Model Properties dialog box in SQL Server Management Studio to set the properties of a mining model in an Analysis Services database.

Mining Structure Properties Dialog (SSAS)

Use the Mining Structure Properties dialog box in SQL Server Management Studio to set the properties of a mining structure in an Analysis Services database.

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 (SSAS)

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 (SSAS)

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 Source Dialog Box (SSAS)

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 (SSAS)

Use the Process dialog box in Business Intelligence Development Studio and SQL Server Management Studio to process Analysis Services objects.

Process Progress Dialog Box (SSAS)

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 (SSAS)

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 (SSAS)

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 (SSAS)

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 (SSAS)

Use the Restore Database dialog box in SQL Server Management Studio to restore an Analysis Services database from a backup file using the Analysis Services Backup File (.abf) format.

Role Designer (SSAS)

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

Save File As Dialog Box (SSAS)

The Save File As dialog box displays a list of available files in log and data folders defined for an Analysis Services instance.

Security Context Dialog Box (SSAS)

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 (SSAS)

Use the Select Language dialog box in Business Intelligence Development Studio to select a language for a new translation.

Select Parent Member Dialog Box (SSAS)

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 (SSAS)

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 (SSAS)

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 (SSAS)

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.

View Details Dialog Box (SSAS)

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 (SSAS)

Use the XMLA Query Editor to design and execute statements and scripts written in the Multidimensional Expressions (XMLA) language.

Show: