SSAS Integration Requirements

The following are the prerequisites necessary for IBM Automatic Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.

SQL Server Analysis Services (SSAS): version 2012 or newer, tabular models up to and including version 1500 — newer tabular models might not work (Azure Analysis Services, most SQL Server 2017 instances; see the SQL Server documentation)
Server must be in SSAS Tabular Model or SSAS Multidimensional Model mode
Able to obtain the database source as an XML or JSON file as per SSAS Manual Inputs

Supported Features

Note: This is a list of SSAS features that Automatic Data Lineage supports. There may be features that aren't explicitly named but are included in the named items, as this list aims to be a high-level overview. Other than that, features that are not listed are primarily considered not supported.

Most features showcased in Analysis Services tutorials
Data source definitions using:
- SQL
- M language (PowerQuery)
MDX:
- Member identifiers containing four parts: [Cube].[Dimension].[Level / Hierarchy].[Member]
- Variables
Tabular model 1500:
- Calculation groups

Known Unsupported Features

Automatic Data Lineage does not support the following SSAS features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.

MDX:
- Functions listed in Table manipulation functions
- Parameterized MDX queries (example in Using Variables and Parameters (MDX))
DMX (Data Mining Extensions (DMX) Reference)
Deduction of objects caused by incomplete input
Using KPI as a data source for another technology (like SSRS)