MSDN

SQL Server Analysis Services Reference

This section provides comprehensive reference documentation for SQL Server Analysis Services (SSAS). It covers the core languages, interfaces, and settings used to design, develop, and manage SSAS solutions.

Multidimensional Expressions (MDX) Functions

MDX is the query language used for the multidimensional mode of Analysis Services. This subsection details the syntax, arguments, and usage of various MDX functions.

• Aggregate Functions
• String Functions
• Numeric Functions
• Time Intelligence Functions
• Set Functions
• Member Functions
• Debugging Functions

Example MDX Query:

SELECT
    {[Measures].[Internet Sales Amount]} ON COLUMNS,
    {[Date].[Calendar Year].MEMBERS} ON ROWS
FROM
    [Adventure Works DW2019]
WHERE
    ([Product].[Category].&[1])

Data Analysis Expressions (DAX) Functions

DAX is the formula expression language used primarily with tabular models in Analysis Services and Power BI. Explore the extensive library of DAX functions.

• Aggregation Functions
• Date and Time Functions
• Filter Functions
• Information Functions
• Logical Functions
• Mathematical and Trigonometric Functions
• Text Functions
• Table Manipulation Functions
• Time Intelligence Functions

Example DAX Measure:

Total Sales Amount = SUM('Sales'[SalesAmount])

XML for Analysis (XMLA) Reference

XMLA is the XML-based protocol used to communicate with Analysis Services. Understand the various XMLA commands and structures for data manipulation and management.

• Discover Commands
• Execute Commands
• XMLA Object Definitions

Analysis Management Objects (AMO)

AMO is a .NET Framework library that allows programmatic management of Analysis Services databases and objects. This section covers the classes, methods, and properties of the AMO object model.

• Database Management
• Cube Design and Deployment
• Data Processing
• Security Management

Configuration Settings

Details on the configuration settings for SQL Server Analysis Services, including instance properties, performance options, and network settings.

• Server Properties
• Memory Management Settings
• Network Protocol Settings

MDX Aggregate Functions

Common aggregate functions like SUM, AVG, COUNT, MAX, and MIN. These operate on sets of members or tuples.

Usage:

AGGREGATE({[Measures].[Sales Amount], [Measures].[Cost Amount]})

DAX Aggregation Functions

Functions such as SUM, AVERAGE, MIN, MAX, COUNTROWS, DISTINCTCOUNT used for aggregating data.

Usage:

AVERAGE('Sales'[Quantity])

More detailed sections for each function and command will be linked here in a complete documentation set.