Reporting Services Report Models - Professional SQL Server 2005 Reporting Services - page 352

Figure 8-16
The Data Source View XML starts with both an ID tag and a Name tag. The ID tag is the object name
given to the Data Source View. When new objects, such as a Report Model, are associated with the Data
Source View, they will reference the value in the ID tag. If the ID values is changed after objects are asso-
ciated with the Data Source View, those items will be unable to read from it. The Name tag is the friendly
name displayed in the Business Intelligence Development Studio interface. This value can be updated as
needed without breaking other items. By default, the ID and Name tag will have the same value.
The next major section of the Data Source View is contained within the Annotation tag. Each Annotation
tag contains information about how the Data Source View should be displayed within the designer.
Annotation tags also contain information related to how initial relationships were established within
the Data Source View. Once the Data Source View is created, the Annotations section does not include
any information crucial to the function of the view; it is solely for display purposes. So, if you delete the
entire section, the Report Model will continue to function. However, you will not have a very pretty
designer to work in.
Following the Annotations tag is the DataSourceID tag. This tag represents a reference to the ID tag in
one of the project's data sources. Modifying this tag can break the relationship between the two objects.
The next tag in the document is the Schema tag. This tag contains the core definition of the Data Source
View. It breaks down into two major areas: elements and relationships.
The document starts with one main element tag. This tag represents the entire Data Source View as a
single complex type. Within the main element tag are element tags for each of the individual tables. The
table element tags contain the name of the object as well as a query or reference to the underlying table.
Within each element tag for a table are element tags for the table's different columns. The column ele-
ment tags contain the columns name, data type, and other defining properties.
After moving through all of the table element tags, you will find a variable list of tags for each unique
constraint within the Data Source View. These tags contain information about primary keys defined
within the view. Each constraint will have an indication of its type as well as an xpath reference to its
related table and column.