Work with Diagrams in Data Source View Designer (Analysis Services)
A data source view (DSV) diagram is a visual representation of the objects in a DSV. You can work with the diagram interactively to add, hide, delete or modify specific objects. You can also create multiple diagrams on the same DSV to focus attention on a subset of the objects.
This topic includes the following sections:
Add a Diagram
Edit a Diagram
Find Tables in a Diagram
Arrange Objects in a Diagram
Add a Diagram
DSV diagrams are created automatically when you create the DSV. After the DSV exists, you can create additional diagrams, remove them, or hide specific objects to create a more manageable representation of the DSV.
To create a new diagram, right-click anywhere in the Diagram Organizer pane, click New Diagram.
When you initially define a data source view (DSV) in an Analysis Services project, all tables and views added to the data source view are added to the <All Tables> diagram. This diagram appears in the Diagram Organizer pane in Data Source View Designer, the tables in this diagram (and their columns and relationships) are listed in the Tables pane, and the tables in this diagram (and their columns and relationships) are displayed graphically in the schema pane. However, as you add tables, views and named queries to the <All Tables> diagram, the sheer number of objects in this diagram makes it difficult to visualize relationships—particularly as multiple fact tables are added to the diagram, and dimension tables relate to multiple fact tables.
To reduce the visual clutter when you only want to view a subset of the tables in the data source view, you can define sub-diagrams (simply called diagrams) consisting of selected subsets of the tables, views, and named queries in the data source view. You can use diagrams to group items in the data source view according to business or solution needs.
You can group related tables and named queries in separate diagrams for business purposes, and to make it easier to understand a data source view that contains many tables, views, and named queries. The same table or named query can be included in multiple diagrams except for the <All Tables> diagram. In the <All Tables> diagram, all objects that are contained in the data source view are shown exactly once.
Edit or Delete a Diagram
When working with a diagram, pay close attention to the commands used for adding and removing objects. For example, deleting an object from a diagram will delete it from the DSV. If you only want to delete it from the diagram, use Hide Table instead.
.gif "Diyagram çalışma alanı sağ tıklatma menüsünün ekran görüntüsü")
Although you can hide objects individually, bringing them back using the Show Related Tables command returns all related objects to the diagram. To control which objects are returned to the workspace, drag them from the Tables pane instead.
Find Tables in a Diagram
If your schema is large, scrolling to a particular table in the Diagram pane may be difficult. However, the following tools make it easy to find a table in a diagram.
Tables pane—For more information about the Tables pane, see Tables (Data Source View Designer) (SSAS).
Table locator in Diagram pane—The table locator is located at the intersection of the vertical and horizontal scroll bars in the lower right corner of the Diagram pane.
Find Table dialog box—available on the Data Source View Designer toolbar or the Data Source View menu
To view instructions about how to find tables in a diagram, see View Objects in Data Source View Designer (Analysis Services).
Arrange Objects in a Diagram
Although Data Source View Designer can define multiple diagrams to make a DSV more understandable, diagrams that contain dozens of tables can be hard to read and manually rearranging table layouts is a tedious process. The Data Source View Designer can automatically rearrange tables in the current diagram using either a rectangular or diagonal layout based on the relationships between tables in the current diagram.
In a rectangular layout, the relationship lines are drawn between tables instead of between columns. Relationship lines are drawn horizontally and vertically between tables.
In a diagonal layout, relationship lines are drawn as directly as possible between related columns in tables. A relationship to multiple columns attaches to the first related column in the table. If the columns in a table are not visible, the lines are drawn to the top of the table.