Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

Tabular Model Programming

SQL Server 2012

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 the xVelocity in-memory analytics engine (VertiPaq) for storage and fast table scans that aggregate and calculate data as it is requested.

Programmatically, the objects you work with in AMO, ADOMD.NET, XMLA, or OLE DB are fundamentally the same for both tabular and multidimensional solutions. If the requirements of your custom BI solution are best met by a tabular model database running on an xVelocity engine, 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.

This section provides more information about how you can programmatically work with tabular model entities and their properties.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.