Figure 1‑8 shows an outline of the demo database analytical model. Not all fields from each table appear in this example.
Household is the main table.
Customer is a sub-table 1.
Order is a sub-table 2.
Order Detail is a sub-table 3.
Figure 1‑8 Demo database tables, fields, and associations
When the administrator loads the demo database into BIRT Analytics, the loader sets up the associations among the tables. Use these implied associations in BIRT Analytics to change the resolution on many types of analyses:
A household can have from 1 to N associated customers.
A customer can have from 1 to N associated orders. A customer must have an associated household.
An order can have from 1 to N associated order detail lines. An order must have an associated customer.
An order detail line must have an associated order.
Household is the main table.