A .NET library that extends AMO and lets code create and manage tabular models, including their tables, columns, measures and roles, through the XMLA endpoint.
Also called Tabular Object Model.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains TOM in context, with comparison tables and the common traps.
Terms in this definition
- AMO
A .NET client library that SSMS and Visual Studio use to administer Analysis Services servers and define their objects; for tabular models, TOM (the Tabular Object Model) builds on top of it.
- CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
- MANAGE
A Unity Catalog privilege allowing a principal to grant and revoke access on an object, hand over its ownership and drop it, all without being the owner. It gives no data access by itself and is not part of
ALL PRIVILEGES. - XMLA endpoint
Opens Premium, Premium Per User and Fabric semantic models to SSMS, Tabular Editor, DAX Studio and similar tools over XMLA. Read-only unless set to read-write per capacity, which also permits deployment and management.
Related terms
- TMDL
A YAML-like text format that stores a tabular semantic model as a folder of .tmdl files, for example one per table or role. It maps fully to TOM, works well with source control, and is what a Power BI Project uses by default.