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:

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:

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.