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 List
| Topic | Description |
|---|---|
Use the Add Cube Dimension dialog box in Business Intelligence Development Studio to add a reference to a database dimension to a cube. |
|
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. |
|
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. |
|
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. |
|
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. |
|
Use the Assembly Properties dialog box in SQL Server Management Studio to set the properties of an assembly reference in an Analysis Services database. |
|
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. |
|
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. |
|
Use the Browse Data Source dialog box in Business Intelligence Development Studio to view the first 1,000 records of the selected table. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
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. |
|
Use the Create/Edit Relationship dialog box in Business Intelligence Development Studio to define or modify a relationship in a data source view. |
|
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. |
|
Use the Cube Properties dialog box in SQL Server Management Studio to set the properties of a cube in an Analysis Services database. |
|
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. |
|
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. |
|
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. |
|
Use the Data Source Designer dialog box in Business Intelligence Development Studio to create or modify a data source. |
|
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 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. |
|
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 Database Designer in Business Intelligence Development Studio to edit the properties of 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. |
|
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. |
|
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 within an Analysis Services project in Business Intelligence Development Studio. |
|
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. |
|
Use the Dimension Properties dialog box in SQL Server Management Studio to set the properties of a dimension in an Analysis Services database. |
|
Use the DMX Query Editor to design and execute statements written in the Data Mining Extensions (DMX) language. |
|
Use the Duplicate Role dialog box in SQL Server Management Studio to duplicate an existing role in an Analysis Services database. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object. |
|
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. |
|
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. |
|
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. |
|
Use the MDX Builder dialog box in Business Intelligence Development Studio or SQL Server Management Studio to build a Multidimensional Expressions (MDX) expression. |
|
Use the MDX Query Editor to design and execute statements and scripts written in the Multidimensional Expressions (MDX) language. |
|
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. |
|
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. |
|
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. |
|
Use the New Database dialog box in SQL Server Management Studio to create a new, empty Analysis Services database. |
|
Use the New Measure dialog box in Business Intelligence Development Studio to add a new measure to a measure group in 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. |
|
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. |
|
Use the Partition Source dialog box in Business Intelligence Development Studio to specify the source of fact table data for a partition. |
|
Use the Process dialog box in Business Intelligence Development Studio and SQL Server Management Studio to process Analysis Services objects. |
|
Use the Process Progress dialog box in Business Intelligence Development Studio and SQL Server Management Studio to monitor processing in Analysis Services. |
|
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. |
|
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. |
|
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. |
|
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 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. |
|
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. |
|
Use Role Designer in Business Intelligence Development Studio and SQL Server Management Studio to define or modify a role. |
|
The Save File As dialog box displays a list of available files in log and data folders defined for an Analysis Services instance. |
|
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. |
|
Use the Select Language dialog box in Business Intelligence Development Studio to select a language for a new translation. |
|
Use the Select Parent Member dialog box in Business Intelligence Development Studio to select a parent member for a calculated member. |
|
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. |
|
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. |
|
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. |
|
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. |
|
Use the XMLA Query Editor to design and execute statements and scripts written in the Multidimensional Expressions (XMLA) language. |
See Also
Reference
Analysis Services Wizards (SSAS)
Analysis Services F1 Help (SSAS)