Introducing the Tabular Editor Blog

Tabular Editor is growing. It’s time to start blogging.

Some background history

It all started back in August 2016, when I was challenged with maintaining a large Tabular Model with more than 50 tables, and over 800 measures. One day, my client asked me to update the display folder structure of half the measures in the model. Initially, I considered using some simple search-and-replae of the Model.bim file, but this quickly turned out to be a bad idea, as the change should not affect measures in certain perspectives. I briefly considered using some kind of RegEx or script to apply the change to the Model.bim file, but quickly realised the futility, as perspective metadata is stored completely separate from the measures themselves.

I realised that I could write a simple C# script that would use the TOM to apply the changes. This solved the problem, and it didn’t take too long to write the script, until the next day, when my client once again wanted me to change some minor detail on a large number of objects. At this point, I realised that changes like this were bound to happen often, so I pieced together a simple GUI, that would list all the measures in the model by Display Folder, to make it easier to apply changes in batches. Soon thereafter, release 1.0 of Tabular Editor was announced on my company’s website.

Features that I actually needed

New features were added to Tabular Editor whenever I encountered a Tabular modelling task that seemed ineffective in SSDT. I had the pleasure of doing lots of Tabular development at my job, and I enjoy coding C# / WinForms in my spare time, so it was the perfect opportunity to flesh out the tool, and design it in a way that would (hopefully) be useful for every SSAS Tabular developer. I also enjoyed lots of early feedback from colleagues, who suggested awesome features such as undo/redo support, batch renamings, automatic formula fix-up, etc. No doubt that my colleagues felt the same way about SSDT as myself.

In general, my feeling is that the tool is well received among developers that already have Tabular modelling experience using SSDT. Most likely, they have also encountered some of the limitations of SSDT, especially when working with larger models, and they could quickly adopt Tabular Editor to fill these gaps in their workflow.

However, the tool is probably not well-suited for first time Tabular developers, as the UI doesn’t really do a lot in terms of “guiding” the user through the development and modelling process. In fact, some tasks may even be less productive in Tabular Editor, than in SSDT (try to add a new Data Table based on a query - Data Columns need to be manually created and mapped to source columns in the current version). When using Tabular Editor, you will no doubt encounter features and functionality that doesn’t make sense for your workflow, or basic features that are downright missing. When you do, don’t hesitate to post an issue on GitHub, and I will be happy to look into how the tool can be improved.

Also, if you’d like to contribute, don’t hesitate to clone the project and submit pull requests, or reach out on Twitter if you would like to become a collaborator on the GitHub project.

More details on the project structure, cloning and building the project, etc. will follow in a separate blog post.

So what’s with the blog?

As mentioned above, this blog will be used as a place where I can vent all my thoughts about Tabular Editor and related technologies. New features will still be announced at the GitHub release site, but rest assured that this blog will contain more details and general discussion that could be of interest, if you like the tool.

You can expect blog posts covering topics such as:

  • Tabular Editor and Version Control
  • Practical Usages of the Best Practice Analyzer
  • Useful scripts and snippets for Tabular Editor
Written on October 17, 2017 by Daniel Otykier