Collections (ASSL)

This reference section contains syntax and usage information for each element that acts as a collection in the Analysis Services Scripting Language (ASSL) schema.

Although the ASSL schema contains only XML elements, from a developer's point of view, the elements described in this section correspond to collections of objects, such as the Dimensions and Cubes collections.

Collections are mostly collections of object elements, in which a plural noun designates the collection (for examples, Cubes), and the collection contains elements designated by the same noun in the singular (for example, Cube).

In some cases, the schema does not adhere to this general rule. For example, the ClassifiedColumns collection contains ClassifiedColumnID elements.

In other cases, a collection contains elements that correspond to object properties, not to objects. For example, the Aliases collection contains Alias properties, each of which is a simple string value.

Element	Description
Accounts Element (ASSL)	Contains the collection of account types that are defined in a Database element.
Actions Element (ASSL)	Contains the collection of actions for a Cube or Perspective element.
AggregationDesigns Element (ASSL)	Contains the collection of aggregation designs that can be shared across multiple partitions in a database.
AggregationInstances Element (ASSL)	Contains the collection of aggregation instances that are defined in a Partition element.
Aggregations Element (ASSL)	Contains the collection of aggregations defined for an AggregationDesign element.
AlgorithmParameters Element (ASSL)	Contains the collection of parameters for the algorithm used by a MiningModel element.
Aliases Element (ASSL)	Contains the collection of Alias elements associated with an Account element
AllMemberTranslations Element (ASSL)	Contains the collection of Translation elements for the caption of the All member of a Hierarchy element.
Annotations Element (ASSL)	Contains the collection of Annotation elements associated with the parent element.
Assemblies Element (ASSL)	Contains the collection of Assembly elements associated with a Server element or a Database element.
AttributeAllMemberTranslations Element (ASSL)	Contains the collection of translations for the caption of the All member of the dimension.
AttributePermissions Element (ASSL)	Contains the collection of attribute permissions for an individual Role element on a specific dimension of a Cube element.
AttributeRelationships Element (ASSL)	Contains the collection of AttributeRelationship elements for the attribute.
Attributes Element (ASSL)	Contains the collection of attributes for the associated dimension.
Blocks Element (ASSL)	Contains the collection of blocks of binary data that represent the binary contents of a ClrAssemblyFile element.
CalculationProperties Element (ASSL)	Contains the collection of CalculationProperty elements associated with an MdxScript element.
Calculations Element (ASSL)	Contains the collection of PerspectiveCalculation elements associated with a Perspective element.
CellPermissions Element (ASSL)	Contains the collection of permissions for cells in the associated Cube element.
ClassifiedColumns Element (ASSL)	Contains the collection of related columns that are classified by the ScalarMiningStructureColumn element.
Columns Element (ASSL)	Contains the collection of columns associated with the parent element.
Commands Element (ASSL)	Contains the collection of Command elements associated with an MdxScript element.
CubePermissions Element (ASSL)	Contains the collection of permissions applicable to a Cube element.
Cubes Element (ASSL)	Contains the collection of Cube elements associated with a Database element.
DatabasePermissions Element (ASSL)	Contains the collection of DatabasePermission elements associated with a Database element.
Databases Element (ASSL)	Contains the collection of Database elements associated with a Server element.
DataSources Element (ASSL)	Contains the collection of DataSourcePermission elements associated with a DataSource data type.
DataSourcePermissions Element (ASSL)	Contains the collection of DataSource elements associated with a Database element.
DataSourceViews Element (ASSL)	Contains the collection of DataSourceView elements associated with a Database element.
DimensionPermissions Element (ASSL)	Contains the collection of permissions applicable to a Dimension element or a CubePermission element.
Dimensions Element (ASSL)	Contains the collection of dimensions associated with the parent element.
Events Element (ASSL)	Defines the collection of Event elements to be captured by a Trace.
Files Element (ASSL)	Contains the collection of File elements that make up a ClrAssembly element.
ForeignKeyColumns Element (ASSL)	Contains the collection of columns that identify the join to the parent table for a relational data source.
Groups Element (ASSL)	Contains the collection of groups of members bound to an attribute.
Hierarchies Element (ASSL)	Contains the collection of Hierarchy elements associated with the parent element.
IncrementalProcessingNotifications Element (ASSL)	Contains the collection of IncrementalProcessingNotification elements that provide information to the ProactiveCaching element about queries to execute to determine the progress of incremental processing.
KeyColumns Element (ASSL)	Contains the collection of KeyColumn element definitions for a parent object.
Kpis Element (ASSL)	Contains the collection of Kpi elements associated with the parent element.
Levels Element (ASSL)	Contains the collection of Level elements in a Hierarchy element.
MdxScripts Element (ASSL)	Contains the collection of MdxScript elements associated with a Cube element.
MeasureGroups Element (ASSL)	Contains the collection of MeasureGroup elements associated with the parent element.
Measures Element (ASSL)	Contains the collection of Measure elements associated with the parent element.
Members Element (ASSL)	Contains the collection of Member elements of the parent element.
MiningModelPermissions Element (ASSL)	Contains the collection of permissions for a MiningModel element.
MiningModels Element (ASSL)	Contains the collection of MiningModel elements associated with a MiningStructure.
MiningStructurePermissions Element (ASSL)	Contains the collection of permissions on a MiningStructure element.
MiningStructures Element (ASSL)	Contains the collection of MiningStructure elements in a Database element.
ModelingFlags Element (ASSL)	Contains the collection of ModelingFlag elements for a column in a MiningStructure or a MiningModel.
NamingTemplateTranslations Element (ASSL)	Provides a collection of localized translations for the NamingTemplate element of the parent DimensionAttribute.
Partitions Element (ASSL)	Contains the collection of Partition elements used by a MeasureGroup element, or the collection of partition bindings that make up an out-of-line MeasureGroupBinding element.
Perspectives Element (ASSL)	Contains the collection of Perspective elements associated with a Cube element.
QueryNotifications Element (ASSL)	Contains the collection of QueryNotification elements that provide information to the ProactiveCaching element about queries to execute to determine whether a data source has been modified.
ReportFormatParameters Element (ASSL)	Contains the collection of ReportFormatParameter elements for a ReportAction element.
ReportParameters Element (ASSL)	Contains the collection of ReportParameter elements for a ReportAction element.
Roles Element (ASSL)	Contains the collection of Role elements defined under the parent element.
ServerProperties Element (ASSL)	Contains the collection of ServerProperty elements associated with a Server element.
TableNotifications Element (ASSL)	Contains the collection of TableNotification elements that provide information for the ProactiveCaching element about tables or views in a data source that have been modified.
Traces Element (ASSL)	Contains the collection of Trace elements associated with a Server element.
Translations Element (ASSL)	Contains the collection of Translation elements associated with the parent element.
UnknownMemberTranslations Element (ASSL)	Contains the collection of translations for the caption of the UnknownMember element of a dimension.

See Also

Reference

Analysis Services Scripting Language XML Element Hierarchy (ASSL)

Help and Information

Getting SQL Server 2005 Assistance