The SSAS multidimensional project DSV diagram is rearranged in Visual Studio

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

Workaround

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

↑ Back to the top

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.

↑ Back to the top