What languages are used in SSAS?

What languages are used in SSAS?

Asked on November 13, 2018 in SQL Server.
Add Comment


  • 3 Answer(s)

    These are the following languages used:

    • Structured Query Language (SQL)

    • Multidimensional Expressions (MDX) – an industry standard query language orientated towards analysis

    • Data Mining Extensions (DMX) – an industry standard query language oriented toward data mining.

    • Analysis Services Scripting Language (ASSL) – used to manage Analysis Services database objects.

    MDX – Multidimensional Expressions. It is used for retrieving data from SSAS cubesand very similar to T-SQL, but very different in the areas of conceptualization and implementations.

    DMX – Data Mining Extensions. This is again used for SSAS but rather than cubes it is used for data mining structures. This language is more complicated than MDX. BI tools provided by Microsoft, further reduced experts for learning this language(data mining structures).

    Analysis Services Scripting Language (ASSL) is an extension of XMLA. ASSL can be used in custom application to communicate with Analysis Services. ASSL is made up of two parts:

        a. A Data Definition Language (DDL), defines an instance of Analysis Services, and database objects that the       instance contains.

        b. A command language that includes commands, such as Create, Alter, or Process, to an instance of Analysis   Services.

    Answered on November 13, 2018.
    Add Comment

    =>  Structured Query Language (SQL)
    ?    Multidimensional Expressions (MDX) – an industry standard query language orientated towards analysis
    ?    Data Mining Extensions (DMX) – an industry standard query language oriented toward data mining.
    ?    Analysis Services Scripting Language (ASSL) – used to manage Analysis Services database objects.

    Answered on January 14, 2019.
    Add Comment

    DMX is a data mining query language, which you use to identify inherent patterns in the data. User Smith is correct regarding which languages can be used on which platform. DAX utilises the xVelocity in-memory analytics engine which performs faster on average than the multidimensional cube technology (ROLAP, MOLAP). MDX is not as fast as DAX queries on a tabular model.

    Answered on January 14, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.