Edit

Share via

Developing with Analysis Services Scripting Language (ASSL)

  • Article

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

Analysis Services Scripting Language (ASSL) is an extension to XMLA that adds an object definition language and command language for creating and managing Analysis Services structures directly on the server. You can use ASSL in custom application to communicate with Analysis Services over the XMLA protocol. ASSL is made up of two parts:

  • A Data Definition Language (DDL), or object definition language, defines and describes an instance of SQL Server Analysis Services, as well as the databases and database objects that the instance contains.

  • A command language that sends action commands, such as Create, Alter, or Process, to an instance of Analysis Services. This command language is discussed in the XML for Analysis (XMLA) Reference.

To view the ASSL that describes a multidimensional solution in SQL Server Data Tools, you can use the View Code command at the project level. You can also create or edit ASSL script in Management Studio using the XMLA query editor. The scripts you build can be used to manage objects or run commands on the server.

See Also

ASSL Objects and Object Characteristics
ASSL XML Conventions
Data Sources and Bindings (SSAS Multidimensional)