O'Reilly logo

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model by Alberto Ferrari Marco Russo and Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16. Interfacing with Tabular

One of the interesting features of SQL Server Analysis Services (SSAS) is that it is possible to interact programmatically with the server, using dedicated libraries and specific commands. By using this feature, you can handle complex scenarios in which you can control a database and a server through code. For example, you can handle the creation of new partitions and the processing of them as soon as new data is available without the need to handle them manually.

There are two ways to manage an SSAS instance:

  • AMO (Analysis Management Object) is a .NET library containing several classes that can be used to manage an instance of SSAS.

  • XMLA (XML for Analysis) is a SOAP (Simple Object Access Protocol)-based XML protocol ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required