THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Alberto Ferrari

Creating a copy of a BISM Tabular project

Using Visual Studio to author SSAS Multidimensional projects, I was used to copy the project, deploy it with another name and then proceed with updates, until I was satisfied with the final result. Then, working with the two projects side-by-side I could check performance and numbers.

I tried the same technique with Visual Studio 2010 with CTP3 Denali with a Tabular model. I created a copy of an existing project but, as soon as I opened it, I got the error “This model is already open in another location by the same user, please close the other project before working on this one”:


The reason for the error is that, copying the project folder, I copied the user settings file too, which contains the workspace database definition. Because the workspace is already in use by the previous instance of the project (which is still open, due to the way I work) and a workspace cannot be used by more than one active project. For more information about the user settings file and the behavior when opening a BIM project in Denali, refer to this very comprehensive post of Cathy Dumas.

The solution to this problem is straightforward (once you learn it, thanks Cathy for explaining this!): just locate and delete the user settings file (which, by the way, is a hidden file, thus you will need to show hidden files before searching for it). As soon as Visual Studio opens a project with no user settings file, it will create a new workspace, detaching the copied project from the original one, and I can work with the two projects side-by-side.

Tabular projects work in a different way, when compared with Multidimensional ones, we just need to learn new tricks, as always. Sorriso

Published Tuesday, September 27, 2011 11:40 AM by AlbertoFerrari



Simran said:

I haven't tried making a copy of a tabular project but it's good to know that they don't work the way we are used to with SSAS projects and the trick to solve this particular problem.


September 29, 2011 3:26 PM

Ian Smith said:

Good to know, thanks!

May 2, 2012 5:53 AM
New Comments to this post are disabled

About AlbertoFerrari

Alberto Ferrari is a Business Intelligence consultant. He his interests lie in two main areas: BI development lifecycle methodologies and performance tuning of ETL and SQL code. His main activities are with SSIS and SSAS for the banking, manufacturing and statistical sectors. He is also a speaker in international conferences like European PASS Conference and PASS Summit.
Privacy Statement