Import VPAX Data into Tabular Editor

Having read the title of this post you may be inclined to think that I am repeating a previous post. However, this new post is the simply the counterpart to my other post.

The other post was about importing Vertipaq Analyzer data from a live-connected model into Tabular Editor. In this post, I am sharing a new script which imports Vertipaq Analyzer data from a .vpax file to Tabular Editor. The result of executing this script is the same in comparison to the script in the previous post. However, this script does not necessitate a connection to a server as all the necessary data exists 'offline' in the .vpax file.

What you need

• .bim file or database.json file

• Vertipaq Analyzer (.vpax) file (for the same model)

Steps

1. Download the script.

2. Paste the script into the Advanced Scripting window in Tabular Editor.

3. Modify the vpaxFile parameter at the top of the script so that it is the location of your .vpax file.

4. Click the play button (or press 'F5').

Just like that, the Vertipaq Analyzer data from the .vpax file has been loaded as annotations in Tabular Editor. And now, as with the other script, you can holistically check the integrity of your model via Best Practice Analyzer rules which reference these annotations. Enjoy!