Database Reference
In-Depth Information
F I g u R e 6 -11
Default Field Set dialog box
Table Behavior
The table behavior properties can be used to set the following properties
for a particular table: Row Identifier, Keep Unique Rows, Default Label, and
Default Image. The Row Identifier allows you to designate the column in the
table that is the unique identifier (primary key) for that table. The Keep Unique
Rows setting allows you to establish which column(s) in the table will be used
to determine unique rows when reporting. So, for instance, in the Chapter 6 -
BISM Model, if the Row Identifier is set to CustomerKey, the Keep Unique Rows
could be set to CustomerAlternateKey or possibly FirstName and LastName.
That way if a customer is in the table multiple times you can report on them
as a single customer instead of multiple customers and avoid sending them
multiple offerings.
The Default Label and Default Image do exactly what you would think—they
allow you to define the label and image for each unique row in the table. So
for the ProductCategory table you would select EnglishProductCategoryName
for the Default Label and CategoryImage for the Default Image. The Default
Image can reference either binary data-type columns or text columns that are
designated as URL references to image files. See Figure 6-12 for an example
of the table behavior dialog box.
