Identifying the Area for Data Input/Output (SAP Library

Identifying the Area for Data Input/Output

Use

Before it can import data into or export data from a matrix, Interactive Excel must be able to identify the data area in the matrix. The data area in a matrix is adjacent to the column and row layout, and consists of cells relating to these layouts. For a simple graphic showing the different elements of a matrix definition, see Data Matrix.

If you define a matrix in which the row and column layouts and their respective cells are unambiguous, Interactive Excel automatically recognizes the data area.

If a layout only occupies a single row or column, it can be confused with the header data and is, therefore, not recognized as a row or column layout. In this case, you are prompted to explicitly specify the data area at the following events:

After you have saved a matrix definition that you have changed by choosing Consolidation ® Data matrix ® Change.
If you choose Consolidation ® Import data in order to fill a matrix with data.

Example

You have inserted a hierarchy of consolidation items in the row layout of a matrix and a version in the column layout. Interactive Excel cannot identify the data area because it does not recognize a layout that only contains one characteristic value.

Activities

1. Select the data area by dragging the cursor over the sheet.

2. Select Choose to the right of the coordinate field to confirm your entry.

3. Choose Confirm.