Select Report Model Generation Rules (Model Designer)
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. |