Specifying Attributes 

Prerequisites

You have specified header data for your matrix. You may have also defined the matrix layout. You now want to insert an attribute into the matrix to provide additional information about a single value, set entry or hierarchy entry. An attribute is not part of the information required for communication between Interactive Excel and the database. Possible attributes are supplied by SAP as well as further custom characteristics.

The information that can be provided by an attribute depends on the characteristic, for example a debit/credit sign or short text can be inserted for a financial statement item.

You cannot insert attributes for a set aggregation, since this characteristic has multiple values.

Procedure

1. Place the cursor on the cell in which you want to insert an attribute.

2. Choose Consolidation ® Attribute and then the relevant characteristic.

A modeless dialog box appears in which you specify the relevant characteristic value.

3. Place the cursor on the cell in which the ID or long text for the value is located.

The cell reference is displayed in the field. Choose OK.

By entering an area, you can also display the attributes for all of the fields within the area.

4. In the next dialog box, select an attribute and choose OK.

You may want to specify an attribute for a characteristic that is dependent on the values of characteristics that you have not yet specified. In order to generate a list of valid attributes, you need to specify these delimiting characteristic values. Only after you have made this specification is a list of attributes displayed.

Result

The attribute is inserted at the cursor position, and can be subsequently formatted, moved, deleted, or changed.

You can use the procedure described above to change an attribute that you have already defined. When you change an attribute, you need to confirm that you want it to be overwritten with new data.