Select Report Model Generation Rules [Model Designer]

  • Article

Use the Select Report Model Generation Rules page to select the rules that are used to generate the metadata from the data source. It is recommended that you use the default selections.

Options

Option Description

Select All

Click to select the check box for each rule.

Clear

Click to clear the check box for each rule.

Select model language

From the drop down list, select the language that you want Model Designer to use when generating user-friendly names for the tables and columns in your database. By default, the language selected is the same language in which you are running your computer. If you select a different language, you must reapply any changes that you made in the rules area. After you complete the wizard, you can set the Culture property for the model.

Rules

Option Description

Create entities for all tables

Select to create an entity for each table regardless of whether there is data in the database table. This option is selected by default.

Create entities for non-empty tables

Select to create an entity for each table only if there is data in the database table. This option is not selected by default.

Create count aggregates

Select to create an aggregate field that contains the number of unique instances within an entity. This option is selected by default.

Create attributes

Select to create an attribute for each column in each table. This option is selected by default.

Create attributes for non-empty columns

Select to create fields for only those columns that contain data in the database. This option is not selected by default.

Create attributes for auto-increment columns

Select to create a hidden field that contains automatically incremented data from the database. This option is selected by default.

Create date variations

Select to create variations for date fields based on different parts of the date, for example, year, months, or days. This option is selected by default.

Create numeric aggregates

Select to create sum, average, minimum and maximum fields for each numeric field. This option is selected by default.

Create date aggregates

Select to create a first date aggregate field and a last date aggregate field for each date field. This option is selected by default.

Create roles

Select to create two roles (one to and one from) for each relationship that is discovered between entities. This option is selected by default.

Lookup entities

Select to treat entities with only one field in them as lookup entities. These entities are placed in a folder called Lookup. This option is selected by default.

Small lists

Select to create drop down lists when there are less than 100 instances within the entity from which to choose. This option is selected by default.

Large lists

Select to require users to choose from a list when there are more than 500 instances within the entity from which to choose. This option is selected by default.

Very large lists

Select to require users to filter before choosing from a list when there are more than 5,000 instances within the entity from which to choose. This option is selected by default.

Set identifying attributes

Select to indicate which fields are unique to that entity. Model Designer identifies potential identifying attributes. This option is selected by default.

Set default detail attributes

Select to indicate which fields are displayed by default when a user clicks a related item in a clickthrough report. This option is select by default.

Role name only

Select to automatically set the contextual name property of the Role attribute. This option is selected by default.

Numeric/date formatting

Select to sort numeric and date fields in descending order. This option is selected by default.

Integer/decimal formatting

Select to format integers using numbers and decimals. This option is selected by default.

Float formatting

Select to set formatting on float fields. This option is selected by default.

Date formatting

Select to select to format datetime fields to only show the date portion, not the time portion, of the field. This option is selected by default.

Discourage grouping

Select to prevent users from grouping on fields that are unique. Identifying attributes have discourage grouping set to True by default. This option is selected by default.

Dropdown value selection

Select to set the Value Selection property to drop down lists for fields with less than 200 unique values. This option is selected by default.

See Also

Concepts

Report Model Designer Wizard F1 Help
Model Designer F1 Help

Other Resources

Working with Model Designer
Model Designer Object Properties

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006
Changed content:
  • Clarified content in the Select model language section.