Determination of Values for Characteristics
The link between the database characteristics (that is, the fields in the totals InfoCube for Business Consolidation
(SEM-BCS) or the fields in the totals database table of Enterprise Controlling Consolidation
(EC-CS)) and the characteristics available in Interactive Excel is preprogrammed. Your assignment of characteristic values in a data matrix to the preset Interactive Excel characteristics enables data to be transferred between the correct database fields and matrix fields.
You can identify a characteristic value by entering one of the following:
A cell reference
A single value
If you use master data and control parameters from a database as proposals when defining characteristics, the value reference of characteristic is automatically set. This reference is automatically adjusted when a characteristic is moved to a different location on a worksheet.
However, you need to specify the value or value reference for characteristics that you have defined as follows:
By manual insertion in a matrix, outside a list of set entries or a hierarchy
By copying and pasting from another matrix
It is helpful to specify missing values or missing value references after you have completed the definition of a matrix. To do this, on the SAP Interactive Excel
tab, click 
Data Matrix
Change
and then specify the missing values.