SQLBits 2020

Deep dive into Tabular Editor's scripting engine

If you're not afraid of a little bit of C# and LINQ, Tabular Editor can take your productivity to a whole new level. This session will teach you how to use Tabular Editor's scripting and Best Practice Analyzer features.

This session is for Analysis Services Tabular model developers who are already familiar with Tabular Editor.

In this session, we will introduce the Tabular Object Model from a C# point of view, as well as the concepts of LINQ. By using just a little bit of code, we're going to transcend beneath the UI of Tabular Editor, to unlock its full potential. You will learn how to write your own scripts and define new Best Practice Analyzer rules. Don't worry if you're new to C# - the examples shown will be easy to follow and are also available on GitHub with lots of comments/documentation, so that you can examine them in more details later on.

Some of the topics covered are:

  • Extending the UI with Custom Actions
  • Auto-creating explicit measures and other objects
  • Generating documentation
  • Creating Best Practice Rules to enforce naming conventions, etc.