Data Reporting/Data Entry Matrix

You can report on the basis of current financial data in an SAP system using a data matrix created in Interactive Excel. A matrix definition consists of several layout areas and a header. The layout of a matrix for reporting is the same as the layout of a matrix for data entry.

Note Note

A matrix for data entry differs from a matrix for reporting. To create a matrix for data entry, in the Settings section, select Data entry matrix. Data entry is allowed for reported data only; this means that the matrix can only use the key figures with the prefix LV*.

End of the note.

Procedure

Create a new matrix by clicking Data Matrix New .
For information, see Creation of a Data Matrix.
Apply global parameters.
If you defined global parameters or if the workbook contains further matrices, the Selected characteristics dialog box opens and you

Optional: Confirm you want to select the characteristics by clicking Continue.

The Data matrix dialog box opens.

Define the matrix header.

In the Data matrix dialog box, on the Characteristics tab, adjust the characteristic values you want to be globally valid for the whole matrix and then click OK.

The matrix header is inserted in the worksheet.

Example Example

	A	B	C
1	Matrix name:	Sheet1D1
2	Aspect:	CS	SAP Consolidation
3	Scaling factor:	1
4	User:	USER
5	Last refresh:	13.1.14 23:00
6	Dimension :	01	Companies
7	Cons group :	CG1	legal Dimension Worldwide
8	Cons unit:	C100	Germany
9	Version :	100	Actual version
10	Fiscal year :	1998
11	Period :	12
12	Cons chart/acct :	01	US, ARE in B/S, COGS
13	Key figure :	CV GC CD	Consolidated data, group currency, cumulative
14	Ledger :	CS	Consolidation ledger
15

End of the example.

Define rows by doing the following:
1. Select the top left cell for the first row.
2. On the Data Matrix tab, click Single values, Sets, or Hierarchies, and then select the characteristic you want to assign to the rows.
3. In the Values of <name of the characteristic>, Set for <name of the characteristic> or Hierarchies for <name of the characteristic> dialog box, on the Possible entries tab, select the entries you want to insert into the worksheet.
4. Select the vertical output format for rows (the values will be inserted into and below the active cell).
5. Select ID and/or a value description to be inserted into the sheet and then click OK.
  The characteristic values are inserted into the active matrix.
  Example
  Select cells B20-B26 and allocate these cells to another characteristic to be used in the rows. To do this, when you select the cells, right-click and select SAP Interactive Excel Allocate and then select a characteristic.
  The Allocate function assigns the range to this characteristic.
  
  Set a value for each cell from the context menu or by typing the value directly into the cell.
  Select cells C20-C26 and then repeat these steps for further required characteristics.
  End of the example.
Define columns by doing the following:
1. Select the top left cell for the first column.
2. On the Data Matrix tab, click Single values, Sets, or Hierarchies, and then select the characteristic you want to assign to the columns.
3. Select the horizontal output format for rows (values will be inserted into and to the right of the active cell).
4. Select ID and/or a value description to be inserted into the sheet and then click OK.
  The characteristic values are inserted into the active matrix.
5. Select cell E18 and on the Data Matrix tab, click Attributes to select a characteristic, for example, Partner unit.
  The characteristic must be available on the worksheet.
6. Select the range of the characteristic (for example, Partner unit), you want attributes to refer to and then click OK.
7. Select the attribute you want to insert into the columns of the matrix and then click OK.
  The attributes are inserted into the columns definition.
8. Insert further attributes by repeating the steps.
The matrix definition is complete.
Import data by clicking Import data.
You can import data for an active matrix, a worksheet, or a whole workbook.