Tabular Model Programming for Compatibility Levels 1050 through 1103

 

Tabular models use relational constructs to model the Analysis Services data used by analytical and reporting applications. These models run on an Analysis Service instance that is configured for tabular mode, using an in-memory analytics engine for storage and fast table scans that aggregate and calculate data as it is requested.

If the requirements of your custom BI solution are best met by a tabular model database, you can use any of the Analysis Services client libraries and programming interfaces to integrate your application with tabular models on an Analysis Services instance. To query and calculate tabular model data, you can use either embedded MDX or DAX in your code.

For Tabular models created in earlier versions of Analysis Services, in particular models at compatibility levels 1050 through 1103, the objects you work with programmatically in AMO, ADOMD.NET, XMLA, or OLE DB are fundamentally the same for both tabular and multidimensional solutions. Specifically, the object metadata defined for multidimensional models is also used for tabular model compatibility levels 1050-1103.

In SQL Server 2016, Tabular models can be built or upgraded to the compatibility level 1200 standard, which uses tabular metadata to define the model. Metadata and programmability are fundamentally different at this level. See Tabular Model Programming for Compatibility Level 1200 and Upgrade Analysis Services for more information.

CSDL Annotations for Business Intelligence (CSDLBI)

Understanding the Tabular Object Model at Compatibility Levels 1050 through 1103

Technical Reference for BI Annotations to CSDL

IMDEmbedded Interface

Tabular Modeling (SSAS)
Tabular Model Designer (SSAS)

Community Additions

ADD
Show: