Scripting Tabular Models using XMLA
In this recipe, you will learn how to create XMLA files that can be used for a variety of purposes including deploying and processing.
Getting ready
Unlike most of our work to this point, we will now be working primarily out of SQL Server Management Studio. We will also be working with a deployed Tabular Model database. If you have not deployed your database yet, refer to the previous recipe for deployment options.
How to do it…
While XMLA can definitely look daunting, generating XMLA scripts is quite easy, as shown in the following steps:
Open up Microsoft SQL Server Management Studio, and connect to the tabular instance you are using for development.
Right-click on the database and navigate to the following sequence of options: Script | Script Database as | CREATE To | New Query Editor Window. This will generate the XMLA script to create the database in the query window. If you want to create a new database on a different server, you can use this script.
The...
