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

The Report Model is generated by going through two passes of rules defined on the Report Server. The
implementation of the rules can be found at the following location:

<install drive>\Program Files\Microsoft SQL Server\MSSQL.<instance>\Reporting
Services\Report Server\ModelGenerationRules.smgl

The following table shows each of the rules and describes how they are implemented against the Data
Source View.

Pass 1

Name Description

Create entities for all tables. Builds Report Model entities for any tables contained in the Data

Source View. System tables and the dtproperties table are
excluded from the Model Generation Wizard.

Create entities for Build report model entities only for tables that have a row count

nonempty tables. greater than 0.

Create count aggregates. For each entity in the Report Model, a count aggregate is added.

If the Data Source View contains a table named Product, an entity
called Product will be created along with an attribute #Product
that represents the count of rows within the Product table.

Create attributes. Creates attributes for each column in a table that is not a foreign

key and not an auto-increment column.

Create attributes for Creates only attributes for columns that contain data. A query

nonempty columns. against the data source is required to identify the number of

unique values stored in a given column. If that number is greater
than 0, the column is included.

Create attributes for If this option is selected, auto-increment columns are also

auto-increment columns. included as attributes of an entity.

Create date variations. For columns that have a data type of DateTime , additional

attributes are added for the day, month, quarter, and year of
each date.

Create numeric aggregates. For columns of type Integer , Float , and Decimal , attributes

for Sum , Average , Min , and Max aggregates of the column are
added.

Create date aggregates. For columns of type DateTime , Min , and Max, aggregates of the

column are added.

Create roles. Creates a role for each primary key-foreign key relationship

defined in the Data Source View.

Table continued on following page