Working with an attribute column
Attributes represent subcategories of a broader category, or dimension. For example, Product Code and Product Name can be attributes of a dimension, Product Line. For an attribute to be useful in a summary table, it must be associated with a dimension field in the data set. The developer typically sets this property at the time of designing the information object or data object. Multiple attribute columns associated with a single dimension field are called peer attribute columns. In a summary table that contains one or more dimension columns, and associated attributes, data in the attribute columns cannot be grouped and does not display subtotals.
In a summary table that contains one or more peer attribute columns, and no dimension columns, data in the attribute columns cannot be grouped and does not display subtotals. In a summary table that contains one or more non-peer attribute columns and no dimension columns, data in the outermost attribute column is grouped and displays subtotal aggregate values.
Inserting an attribute column
Attribute columns appear following the associated dimension column in a summary table. When you insert an attribute column in a summary table containing the associated dimension column, the attribute appears after the dimension column.
The example in Figure 6-14 shows a dimension column, Country, an associated attribute column, State, and a measure column, Quantity Ordered. There are no grouped columns in the summary tables and BIRT Studio displays aggregate values for the entire table.
Figure 6-14  
When you insert an attribute column in a summary table that does not contain an associated dimension column, or other attribute columns, the attribute column is inserted to the left in the report table, but cannot be grouped if it is the only attribute column in the summary table. When you insert one or more non-peer attribute columns in a summary table with no dimension columns, you can group data in the outermost attribute column, and subtotal values are displayed for this grouped column.
The example in Figure 6-15 shows two non-peer attribute columns, State and Product Name and one measure column. Data in the State column is grouped, and aggregate data values are displayed for each group. When you insert an attribute column in a summary table containing a dimension column that is not associated with it or the other attribute columns in the summary table, the new column appears in the position you select, as shown in Figure 6-16.
Figure 6-15  
Figure 6-16  
Modifying an attribute column
You can modify an attribute column to change column width, reorder columns, create hyperlinks, create filters, sort data, modify alignment, format data, and change font properties. To modify an attribute column, select the column, and choose an option from the context menu, as shown in Figure 6-17.
Figure 6-17  
Moving an attribute column
In a summary table containing multiple dimensions and associated attribute columns, you can reorder attribute columns only among peer attribute columns. To move an attribute column, select the column, and choose Reorder Columns from the context menu. When you move a dimension column with its associated attribute columns in a summary table, the columns are placed in their new position as a single unit. You cannot move the dimension column without moving the associated attribute columns.
Deleting an attribute column
To delete an attribute column, select the column, and choose Delete. When a dimension column containing associated attributes is deleted from a summary table, the attributes remain in the summary table. To delete each attribute column select each column, and choose Delete.

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2