| 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. |