Advanced Tab (Table/New Table Dialog Box)
Use this tab to further define the fields in a model.
Options
Allow Nulls
Specify that the field can contain nulls. Clearing this will cause the application to omit explicit null checks from the SQL database.
Denormalized
Specify that the selected field is a duplicate of a field in another table. Sometimes databases are denormalized for efficiency purposes.
For example, in a database containing Sales, Customers, and Products tables, the product name appears both in the Products table and in the Sales table. This allows a question such as, "Who bought a sprocket last week?", to be answered without a join to the Products table. This property is set on the Product Name field in the Sales table, indicating it is the same as the Product field in the Products table. English Query then can take advantage of the denormalization, rather than treating the fields as if they are two different fields that happen to have the same, or similar, names.
Aggregate
Specify that the selected field is an aggregate for a field in another table. Available only for numeric fields (for example, an average or total field).
Computed Field
Specify that the value of this field is derived from a computation, rather than occurring in a database table. Add or edit an
An example is dbo.titles.ytd_sales-dbo.titles.advance or datediff(year, dbo.employee.hire_date, getdate()).