Entering content frame

Function documentation Definition of a Matrix Locate the document in its SAP Library structure

Purpose

n this process, you define the row and column layout of a data entry form or report matrix by arranging characteristics and characteristic values on a worksheet.

Prerequisites

You have completed the process Creation of a Data Matrix, in which you make basic settings for your matrix.

Process Flow

1. You define characteristic values and insert them into the worksheet as a row and column layout.

You can specify characteristics and their values in the following ways:

Note

The advantage of selecting values from lists of proposals is that the reference of the cell in which a characteristic value is located is automatically recognized by Interactive Excel, and does not need to be explicitly specified. For more information see Determination of Values for Characteristics.

If you use proposals, you can display either the key, the short or long text, or everything, in the matrix. If, in addition to the key, you use the long text, the long text automatically changes if you choose a different characteristic value by entering a new key.

The following types of characteristics can be used to define the matrix layout:

You can arrange these in sequence, either horizontally or vertically.

A series of single values arranged in sequence, either horizontally or vertically.

A single entry in the matrix definition that summarizes data for all set entries.

A series of single values arranged vertically with a structure of up to 8 levels.

You can insert an unlimited number of single values, sets, and hierarchies into your data matrix, and subsequently delete, move, format, or change them.

When you insert a single value or set aggregation into a cell on the sheet, a help function for values is automatically set for this cell. You can display a list of possible values for the characteristic by positioning the cursor on the cell and using the function button that appears. This function enables you to change a characteristic value quickly and easily.

Caution

If you subsequently change a characteristic value in a report matrix when connected to a database, the matrix is automatically refreshed with appropriate database data.

Caution

When you use the Consolidation menu in Interactive Excel to set values for characteristics that you want to insert into a matrix, you need to define any delimiting characteristics before a proposal list can be generated.

The following table shows the characteristics supported by Interactive Excel, and their dependencies:

Characteristic

Characteristic required

In SAP dependent on...

In Access dependent on...

Dimension

X

    

Cons chart of accounts

X

    

FS item

X

Cons chart of accounts

Cons chart of accounts

Version

X

    

Fiscal year

X

    

Period

X

    

Consolidation group

  • Single value
  • Attributes

 

 

 

  • Hierarchy

Characteristic required, if:

- no ledger or
- no consolidation unit or
- consolidated data (posting level 30)

 

  • Dimension
  • Dimension
  • Version
  • Fiscal year

 

  • Dimension
  • Version
  • Fiscal year
  • Period

 

  • Dimension
  • Dimension
  • Version
  • Fiscal year

 

./.

Consolidation unit

  • Single value
  • Attributes

 

 

  • Set

 

 

 

 

  • Hierarchy

 

 

Characteristic required, if no cons group

 

  • Dimension
  • Dimension
  • Fiscal year

 

  • Dimension
  • Fiscal year
  • Period
  • Version

 

  • Dimension
  • Fiscal year
  • Period
  • Version

 

  • Dimension
  • Dimension
  • Fiscal year

 

  • Dimension
  • Fiscal year
  • Period

 

 

  • Dimension
  • Fiscal year
  • Period
  • Version

Partner unit

  • Single value/Set
  • Attributes
  

 

  • Dimension
  • Dimension
  • Fiscal year

 

  • Dimension
  • Dimension
  • Fiscal year

Key figure

X

    

Subitem category

      

Subitem

  

Subitem category

Subitem category

Unit of measure

      

Year of acquisition

      

Custom characteristic

      

Transaction currency

      

Document type

  

Dimension

Dimension

Ledger

Characteristic required, if no cons group

    

Reference version

      

Reference fiscal year

      

Reference period

      

Posting level

  

Key figure

  

Note

Data is aggregated for characteristics without a defined value. If, for example, a receivables item has a breakdown by trading partner and transaction currency and you do not specify a value for the trading partner breakdown, the sum of all data records with a trading partner assignment is calculated (reporting) or must be entered (data entry) for this item. If a row or column contains no specified characteristics, it can be used for a user-defined entry, for example an Excel formula.
  1. You have the option of displaying additional information for certain characteristics in any cell, in the form of an attribute.

Example

You can display the debit/credit sign of a financial statement item or the currency, text, or language of a company. This additional information is irrelevant for the import (reporting) and export (entry) of data, since it has no influence on the matrix definition.
  1. You make sure that values or value references are set for all the characteristics that you have defined, so that data can be saved correctly to or imported correctly from the database.
  2. You specify any remaining required characteristics and check your global settings.
  3. To check the data structure of the data matrix, choose This graphic is explained in the accompanying text or Consolidation or SEM ® Data matrix® Check.

 

 

 

 Leaving content frame