Focus
attributes depend on a single focus component. For
example, store type might be a focus attribute of
the focus component store. The values of focus attributes
are expressions over values that are already contained in the original
database tables.
You can define focus attributes
on the following properties pages:
General
- Name
- The name for a focus attribute must be unique.
- Description
- Optionally, you can add
more information about the focus attribute.
Definition
- Focus component
- You must select the focus component for which you want to define
the focus attribute by selecting a focus component from the drop-down
list.
- Focus attribute definition
- You
can define focus attributes by selecting one column or by
defining an SQL expression that is based on several columns.
- Based on one column
- If you want to define a focus
attribute that is based on one column,
you can select the column from the available columns. To browse the
columns in an input table, click Plus (+) next
to the table name.
- Based on a column expression
- If you want to define a focus attribute that is based on a column
expression, click SQL to open the SQL Expression
Builder. With the SQL Expression Builder, you can select several columns
to build an SQL expression.
Result Column
You
must define a name for the result column in the output table. The
name must be a valid Db2® column
name. By
default, the result column name is derived from the name of the focus
attribute.
If you rename a focus attribute, the result column name
is also changed. If you change the result column name in the focus
attribute properties, the name of the focus attribute is not changed.
You can
override the default data type of the result columns. The drop-down
list shows the available data types.
The data
type must be compatible with the result type of the defined SQL expression.
If you selected to aggregate the values as percentages, the data type
must be numeric.