Edit

ASSL Objects and Object Characteristics

  • Article

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

Objects in Analysis Services Scripting Language (ASSL) follow specific guidelines in regards to object groups, inheritance, naming, expansion, and processing.

Object Groups

All Microsoft SQL Server SQL Server Analysis Services objects have an XML representation. The objects are divided into two groups:

Major objects
Major objects can be independently created, altered, and deleted. Major objects include:

  • Servers

  • Databases

  • Dimensions

  • Cubes

  • Measure groups

  • Partitions

  • Perspectives

  • Mining models

  • Roles

  • Commands associated with a server or database

  • Data sources

Major objects have the following properties to track their history and status.

  • CreatedTimestamp

  • LastSchemaUpdate

  • LastProcessed (where appropriate)

Note

The classification of an object as a major object affects how an instance of SQL Server Analysis Services treats that object and how that object is handled in the object definition language. However, this classification does not guarantee that SQL Server Analysis Services management and development tools will allow the independent creation, modification, or deletion of these objects.

Minor objects
Minor objects can only be created, altered, or deleted as part of creating, altering, or deleting the parent major object. Minor objects include:

  • Hierarchies and levels

  • Attributes

  • Measures

  • Mining model columns

  • Commands associated with a cube

  • Aggregations

Object Expansion

The ObjectExpansion restriction can be used to control the degree of expansion of ASSL XML returned by the server. This restriction has the options listed in the following table.

Enumeration value Allowed for <Alter> Description
ReferenceOnly no Returns only the name, ID, and timestamp for the requested object and for all contained major objects recursively.
ObjectProperties yes Expands the requested object and minor contained objects, but does not return major contained objects.
ExpandObject no Same as ObjectProperties, but also returns the name, ID, and timestamp for contained major objects.
ExpandFull yes Fully expands the requested object and all contained objects recursively.

This ASSL reference section describes the ExpandFull representation. All other ObjectExpansion levels are derived from this level.

Object Processing

ASSL includes read-only elements or properties (for example, LastProcessed) that can be read from the SQL Server Analysis Services instance, but which are omitted when command scripts are submitted to the instance. SQL Server Analysis Services ignores modified values for read-only elements without warning or error.

SQL Server Analysis Services also ignores inappropriate or irrelevant properties without raising validation errors. For example, the X element should only be present when the Y element has a particular value. The SQL Server Analysis Services instance ignores the X element instead of validating that element against the value of the Y element.