Understanding the sample data model

Figure 1-3 shows an outline of the demo database analytical model. Not all fields from each table appear in this example.

Household is the parent table.

Customer is child table 1.

Order is child table 2.

Order Detail is child table 3.

Figure 1-3

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.

 

Copyright Actuate Corporation 2013

BIRT Analytics 4.2