Demo environment for running queries

To be able of running the samples in this blog you have to have access to an SQL Server Tabular instance and an SQL Server instance. The versions can be either 2012 or 2014.

Then you have to download and install the sample databases at Codeplex. The files you will look for should be named something like “AdventureWorksDW2012 Data File” and “AdventureWorks Tabular Model SQL Server 2012”. The first file is an SQL Server database and should be attached to your SQL Server instance.

The second file is the Tabular model. In the zip file it will be an *.sln file that you can open using Data Tools. In this solution there should be one model called “Model.bim”. Open this model and change connections as described below.

  • In the menu click on “Models” then “Existing connections”. Please change this connection to point to your recently added SQL Server database.
  • Right click on the solution file and change “Server” to your Tabular instance. Make sure “Query Mode” is “In-Memory”.
  • Right click the model and select “Properties”. Please change the “Workspace server” to your Tabular instance
  • Then try to process the model by choosing “Model”, “Process” and then “Process all”. If this succeeds you can then deploy the model by hitting “Build” and then “Deploy”.

If all the steps above succeeds your are ready to rumble 🙂 If you get some kind of errors please try to google the error message.

Advertisements