The SSAS multidimensional project DSV diagram is rearranged in Visual Studio

Applies to: Microsoft SQL Server 2005 Developer EditionMicrosoft SQL Server 2005 Enterprise EditionMicrosoft SQL Server 2005 Enterprise X64 Edition

Symptoms


Consider the following scenario:
  • You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database project that is opened by Microsoft Visual Studio.
  • You open a diagram that is not the <All Tables> diagram in this project.
  • You add an object to the diagram. For example, you add a new table that is not in the <All Tables> diagram.
  • You switch back to the <All Tables> diagram.

In this scenario, the layout of the tables and their relationships may be rearranged in the <All Tables> diagram.

Note This issue affects rectangular layouts and diagonal layouts differently. If the <All tables> diagram is rectangular, only the relationship connectors are rearranged. If the <All tables> diagram is diagonal, both the object positions and the connectors are rearranged, and this makes the diagram resemble a spider web.

Cause


This issue occurs because the <All Tables> diagram detects that the number of tables has changed, and then the diagram is redrawn. Therefore, multiple objects are arranged in different locations.

Workaround


To work around this issue, add new objects to the <All Tables> diagram before you add them to other diagrams.

More Information


When you open a SQL Server Analysis Services multidimensional database project in Visual Studio, you can open a data source view to work on the definition of different diagrams. The <All Tables> diagram is the default diagram that contains all the tables, views, relationships, and queries that are named. Each diagram object has a fixed position in the diagram. You can also define other diagrams. These diagrams contain a subset of objects from the <All Tables> diagram.