Properties (ASSL)
This reference section contains syntax and usage information for each element that acts as an object property 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 properties that describe objects.
Properties are leaf-level elements in the ASSL schema, and do not have child elements or elements that correspond to properties of their own.
In a few cases, a leaf-level element in the schema that may appear to be a property is classified as an object because the element's type is an object type. For example, the Source of a Dimension object is of type DimensionBinding.
In This Section
Element |
Description |
|---|---|
Indicates the level of access given to a CellPermission element. |
|
Contains the name of the user account for the ImpersonationInfo data type. |
|
Contains the name of an account type defined in a Database element. |
|
Contains the name of an Action element defined on a Cube element which is made available in a Perspective element as a PerspectiveAction element. |
|
Indicates whether the associated permission includes the right to administer a Database element. |
|
Defines the type of aggregate function used by a Measure element. |
|
Identifies the AggregationDesign element associated with the Partition element. |
|
Contains the aggregation function to use for the account type. |
|
Identifies the aggregation definition from the AggregationDesign element used to create the aggregation instance. |
|
Identifies the source of data for user-defined aggregation instances bound to a Partition element. |
|
Defines the common prefix to be used for aggregation names throughout the associated parent element. |
|
Identifies the storage method for aggregations. |
|
Defines the type of aggregation stored by the Partition element. |
|
Controls how the Aggregation Designer in Microsoft SQL Server Analysis Services designs aggregations. |
|
Defines the algorithm used by a MiningModel element. |
|
Defines an alias for an Account element. |
|
Controls how the Aggregation Designer in Analysis Services designs aggregations. |
|
Contains the caption in the default language for the All member of a Hierarchy element. |
|
Defines whether the members of a Role element have browse permission on a MiningModel element. |
|
Determines whether drillthrough is permitted on the parent element. |
|
Determines whether duplicate names are allowed in a Hierarchy element. |
|
Contains a set expression that defines the set of allowed permissions for a Role element on an attribute. |
|
Identifies the application associated with an Action element. |
|
Contains the identifier (ID) of the MeasureGroup element associated with a CalculationProperty element or a Kpi element. |
|
Contains the caption, in the default language, for the All member of the dimension. |
|
Identifies the folder in which to display the associated attribute hierarchy. |
|
Determines whether an attribute hierarchy is enabled for the attribute. |
|
Determines the level of optimization applied to the attribute hierarchy. |
|
Determines whether the associated attribute hierarchy is ordered. |
|
Determines whether the attribute hierarchy is visible to client applications. |
|
Contains the ID of the attribute associated with the parent element. |
|
Specifies that a Trace element cannot drop any events, even if this results in degraded performance on the server. |
|
Determines whether a Trace element should automatically restart if the Analysis Services service stops and restarts. |
|
Describes color-related display characteristics of the parent element. |
|
Determines the caching mechanism used for training data retrieved while processing a mining structure. |
|
Contains the name of the named set or calculated cell referenced by the CalculationProperty element. |
|
Describes the type of calculation defined in the associated CalculationProperty element. |
|
Defines the end date of the calendar period for a TimeBinding element. |
|
Defines the calendar language used for the TimeBinding element. |
|
Defines the start date of the calendar period for the TimeBinding element. |
|
Contains the caption for the associated parent element. |
|
Defines whether the caption for the Action element is a Multidimensional Expressions (MDX) expression. |
|
Indicates the cardinality of the relationship described by an AttributeRelationship or RegularMeasureGroupDimension. |
|
Contains the ID of the cube dimension that relates the data mining dimension to the measure group. |
|
Contains the ID of a related column that is classified by the ScalarMiningStructureColumn element. |
|
Determines the collation used by the parent element. |
|
Contains the ID of the column within the table to which the data item is bound. |
|
Contains the ID of the column of information to be captured for an event as part of a Trace element. |
|
Contains an MDX expression that determines whether the Action parent element applies to the target. |
|
Contains the encrypted connection string for a DataSource element. |
|
Specifies whether the user's password is stripped from the data source connection string for security purposes. |
|
Describes the content of the column in the MiningStructure element. |
|
Contains the read-only creation timestamp of the parent element. |
|
Identifies the CubeDimension element associated with the parent element. |
|
Identifies the Cube element associated with a Binding element. |
|
Determines the current storage mode for the parent element. |
|
Defines the current member of a time dimension associated with a Kpi element. |
|
Determines whether the instance can aggregate persisted data or cached data for the MeasureGroup. |
|
Identifies the Database element associated with an out-of-line Binding element. |
|
Contains the size in bytes of a DataItem element. |
|
Identifies the DataSource element associated with the parent element. |
|
Contains the information used to determine impersonation behavior when connecting to the data source for a Database element. |
|
Identifies the DataSourceView element associated with the Binding parent element. |
|
Defines the data type of the associated element. |
|
Contains the name of the schema used by the parent element in the table identified by the DbTableName element. |
|
Contains the name of the table to which the parent element is bound. |
|
Determines whether the DrillThroughAction is the default drillthrough action. |
|
Contains an MDX language expression that defines the default measure for a Cube or Perspective element. |
|
Contains an MDX expression that identifies the default member of the parent element. |
|
Identifies the default MdxScript element in the MdxScripts collection. |
|
Contains the read-only default value of the associated ServerProperty element. |
|
Contains a set expression that defines the list of permissions that are denied on the associated attribute. |
|
Contains the ID of another dimension on which the parent dimension depends. |
|
Contains the description of the parent element. |
|
Contains the ID of the dimension. |
|
Contains the number of buckets into which to discretize. |
|
Defines the method to be used for discretization. |
|
Contains a read-only hint that indicates whether user interface components should display the associated ServerProperty element. |
|
Specifies the folder in which to list the parent element. Analysis Services applications for developers and administrators may support the use of display folders to categorize multiple elements visually. |
|
Contains a provider-specific value that describes how scalar values are distributed within a column of a MiningStructure element. |
|
Contains the read-only edition of the instance of Analysis Services represented by the Server element. |
|
Indicates whether the parent element is enabled. |
|
Indicates the end of data received from a PushedDataSource element. |
|
Contains the estimated number of members for an attribute. |
|
Contains the read-only percentage of estimated performance gain for the partition. |
|
Contains the estimated number of rows represented by the parent element. |
|
Contains the read-only estimated size, in bytes, of the parent element. |
|
Uniquely identifies an Event element that is to be captured as part of a Trace element. |
|
Contains an MDX expression that defines the contents of the parent element. |
|
Contains an MDX expression that filters the contents of the parent element. |
|
Contains an XML document fragment that describes the Trace filter. |
|
Defines the first day of the week for a TimeBinding element. |
|
Defines the first day of the fiscal month for a TimeBinding element. |
|
Defines the first month of the fiscal period for a TimeBinding element. |
|
Defines the naming convention for the name of the fiscal year for a TimeBinding element. |
|
Describes font-related display characteristics of the CalculationProperty or Measure parent element. |
|
Describes font-related display characteristics of the CalculationProperty or Measure parent element. |
|
Describes font-related display characteristics of the CalculationProperty or Measure parent element. |
|
Determines the amount of time, starting when a fresh multidimensional OLAP (MOLAP) image becomes available, after which MOLAP imaging unconditionally starts. |
|
Describes color-related display characteristics of the CalculationProperty or Measure parent element. |
|
Contains the required format of the DataItem element. |
|
Describes the display format for a CalculationProperty element or a Measure element. |
|
Identifies the desired goal in a Kpi element. |
|
Contains the ID of the attribute associated with the parent MeasureGroupAttributeBinding data type. |
|
Indicates whether and when a member in a level should be hidden from client applications. |
|
Contains the ID for a CubeHierarchy, MeasureGroupHierarchy, or PerspectiveHierarchy element. |
|
Determines how unique names are generated for hierarchies that are contained within the CubeDimension. |
|
Contains the unique ID of the parent element. |
|
Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query. |
|
Contains the information that is used to determine impersonation behavior when accessing or executing an assembly. |
|
Contains a read-only value that indicates if any changes were made to the security credentials that are supplied in the ImpersonationInfo data type. |
|
Contains a value that indicates the method of impersonation for elements that are derived from the ImpersonationInfo data type. |
|
Provides a hint to client applications to suggest how a list of items should be displayed, based on the expected number of items in the list. |
|
Contains the ID of the dimension that relates a reference dimension to a measure group. |
|
Contains the ID of the granularity attribute in the intermediate cube dimension that is used to relate a reference dimension to an intermediate dimension. |
|
Specifies the handling method for XML characters in the source data that are not valid. |
|
Specifies how an Action should be invoked. |
|
Specifies whether the values of the DimensionAttribute element can be aggregated. |
|
Indicates whether the column provides the key for the case in a MiningStructure element. |
|
Indicates the isolation level for an element that is derived from the DataSource data type. |
|
Determines how Analysis Services handles a duplicate key error if it encounters one during processing. |
|
Specifies the action for Analysis Services to take when an error occurs on a key. |
|
Contains the number of acceptable errors during processing. |
|
Specifies the action that Analysis Services takes when the key error count that is specified in the KeyErrorLimit element is reached. |
|
Contains the file name for logging processing errors. |
|
Specifies how Analysis Services responds when it encounters a referential integrity error. |
|
Indicates whether the relationship between the attribute key and its name, and the relationship to related attributes, is guaranteed to be valid. |
|
Contains an ID that associates a Kpi element with a Perspective element. |
|
Contains the language identifier of the parent element. |
|
Contains the read-only timestamp that indicates when the database that contains the parent element was last processed. |
|
Contains the read-only metadata update timestamp of the parent element. |
|
Contains a read-only timestamp that indicates the last time that the associated Database or any of the major objects that the database contains were altered. |
|
Defines the "grace period" between the earliest notification and the moment when the MOLAP images are destroyed. |
|
Determines whether the Trace element appends its logging output to the existing log file, or overwrites it. |
|
Contains the file name of the log file for the Trace element. |
|
Specifies whether logging of Trace output should roll over to a new file or should stop when the maximum log file size that is specified in LogFileSize is reached. |
|
Specifies the maximum log file size, in megabytes. |
|
Contains the name of the managed provider that is used by an element that is derived from the DataSource data type. |
|
Defines the month of the manufacturing period to which an extra month is assigned for a TimeBinding element. |
|
Defines the first manufacturing month for a TimeBinding element. |
|
Defines the first week of the manufacturing month for a TimeBinding element. |
|
Contains the master data source ID for a Database element. |
|
Indicates the type of relationship between the measure group and the reference dimension. |
|
Contains the maximum number of concurrent connections allowed by an element that is derived from the DataSource data type. |
|
Determines how missing members are handled for MDX statements. |
|
Contains the MDX expression that defines a measure. |
|
Associates a MeasureGroup with the parent element, binding, or out-of-line binding. |
|
Associates a Measure element with the parent element. |
|
Determines whether a prefix is applied to measures in the MeasureGroup. |
|
Determines whether member names under the parent element must be unique. |
|
Determines how unique names are generated for members of hierarchies contained within the CubeDimension element. |
|
Determines whether to display data members for non-leaf members in the parent attribute. |
|
Provides a template string that is used to create captions for system-generated data members. |
|
Contains the Multipurpose Internet Mail Extensions (MIME) type, if applicable, of the data represented by the parent DataItem element. |
|
Associates a mining model with a data mining dimension. |
|
Contains the name of the parent element. |
|
Defines how levels are named in a parent-child hierarchy constructed from the DimensionAttribute parent element. |
|
Determines the non-empty behavior associated with the parent of the CalculationProperty element. |
|
Specifies whether Microsoft SQL Server or an external client application processes the notifications. |
|
Specifies the action to be taken when a null conversion error is encountered. |
|
Determines how the Analysis Services processing engine handles a null key error encountered during processing. |
|
Defines how null values are processed. |
|
Specifies whether the database is brought back online immediately when the rebuilding of the cache is initiated, or only when the rebuilding of the cache is complete. |
|
Determines the level of optimization that is applied to the hierarchy. |
|
Indicates the optionality of the members for an AttributeRelationship element. |
|
Describes how to order the members contained in the attribute. |
|
Identifies another attribute by which to order the members of the Dimension attribute. |
|
Indicates the ordinal number to bind to in collections such as keys and translations. |
|
Indicates the override behavior of the relationship described by an AttributeRelationship element. |
|
Associates a Partition element with a parent element, binding, or out-of-line binding. |
|
Contains the password of the user account for the ImpersonationInfo element. |
|
Contains the path, as provided by an instance of Microsoft SQL Server Reporting Services, of a report used by the ReportAction element. |
|
Contains the read-only pending value of the associated ServerProperty element. |
|
Identifies the permission set associated with a Microsoft .NET Framework assembly. |
|
Determines which parts of the bound source data are dynamic and are checked for updates using the frequency specified by the RefreshPolicy element. |
|
Determines whether a user can process the owner of the parent element. |
|
Indicates whether the instance should index and aggregate during or after processing. |
|
Determines the processing priority of the parent object during background operations, for example lazy aggregation, indexing, or clustering. |
|
Contains the parameterized text of the query to execute for notification of incremental processing status. |
|
Contains the read-only product name of the instance of Analysis Services that is associated with a Server element. |
|
Contains the text of the query to execute for the notification. |
|
Contains an opaque expression for a query associated with a DataSource element in a QueryBinding element. |
|
Determines whether data or metadata can be read for a given CubeDimensionPermission or Permission element. |
|
Determines whether members can read the definition of the database or the definition of objects in the database. |
|
Determines how unique names are generated for hierarchies that are contained within the CubePermission. |
|
Specifies the interval at which the bound data associated with the parent element is refreshed. |
|
Determines how often the dynamic part of the dimension or measure group (as specified by the Persistence element) is checked for changes. |
|
Indicates whether member relationships for an AttributeRelationship can be changed. |
|
Specifies the ID of the OLAP data source that points to the instance of Analysis Services that stores the remote partition. |
|
Defines the first reporting month for the TimeBinding element. |
|
Defines the first week of the reporting month for the TimeBinding element. |
|
Defines the reporting week-to-month pattern for the TimeBinding element. |
|
Contains the name of the Reporting Services instance that is used by the ReportAction. |
|
Contains a read-only value associated with a ServerProperty element that determines whether changing the value of the server property requires that the instance be restarted for the change to take effect. |
|
Identifies the role for which permissions are being defined. |
|
Contains the data (rowset) for a data source. |
|
Determines how the root member or members of a parent attribute are identified. |
|
Contains the schema of the data source view. |
|
Indicates whether the server should build the script cache during processing or after processing. |
|
Defines the minimum amount of time the instance of Analysis Services pauses before starting the MOLAP imaging process. |
|
Defines the amount of time that must elapse after receiving initial notification before MOLAP imaging begins unconditionally. |
|
Contains an MDX expression defining the slice contained in a partition. |
|
Indicates the solve order in which the CalculationProperty element is applied to a calculated member or calculated cell definition. |
|
Identifies the source of data to which the parent element is bound. |
|
Contains the file name or programmatic identifier (ProgID) for a Component Object Model (COM) component. |
|
Contains the details of the source containing the value of the Measure element. |
|
Contains the ID of the source attribute on which the Level element is based. |
|
Contains the ID of the source mining structure column in the ancestor MiningStructure element. |
|
Contains a read-only value that describes the current processing state of the parent element. |
|
Contains an MDX expression that returns a status indicator for a Kpi element. |
|
Contains the recommended graphical representation of the status of the Kpi element. |
|
Specifies the date and time at which a Trace element should stop. |
|
Contains the file system storage location for the contents of the parent element. |
|
Determines the storage mode for the parent element. |
|
Contains the ID of the table (from the DataSourceView element) associated with the parent element. |
|
Identifies the target of the Action element. |
|
Identifies the item type of the item identified in the Target element. |
|
Contains the text of a Command element. |
|
Specifies the time, in seconds, after which an attempt to retrieve data reports a timeout. |
|
Contains an MDX expression that returns a trend indicator for a Kpi element. |
|
Contains the recommended graphical representation of the trend of the Kpi element. |
|
Specifies how data from the data source is trimmed. |
|
Contains the type of the Action element. |
|
Contains the type of the attribute binding. |
|
Specifies the file type of one of the files that belong to a .NET Framework assembly. |
|
Provides information about the contents of the dimension. |
|
Contains the type of the attribute. |
|
Specifies the type of the MeasureGroup. |
|
Contains the type of a MeasureGroupAttribute element. |
|
Contains the type of the MiningStructureColumn element. |
|
Contains the type of the Partition element. |
|
Indicates the type of the PerspectiveCalculation element. |
|
Indicates whether the unknown member is visible. |
|
Contains the caption, in the default language of the dimension, for the unknown member of the dimension. |
|
Describes how an attribute is used. |
|
Describes how the associated column in the parent MiningStructure is used. |
|
Contains the value of the parent element. |
|
Contains the read-only version number of the instance of Analysis Services represented by the Server element. |
|
Defines the visibility of an Annotation element. |
|
Determines the visibility of the parent element. |
|
Contains an MDX expression that determines whether visual totals are displayed for members of this attribute. |
|
Determines whether data or metadata can be written for a given CubeDimensionPermission or Permission element. |
|
Indicates whether dimension writebacks are available (subject to security permissions). |