Show TOC

Function documentationInformation about the Origin of Data Locate this document in the navigation structure

 

You can view important information about the status and the origin of data in a data matrix, a pivot table, or an individual cell on a worksheet.

Features

Origin of Data in a Matrix

You can display and, if required, insert the following information into the worksheet at the cursor position:

  • Characteristics used in the matrix and their values

  • Logon user name with which data was imported

  • System/Database from which data was imported

  • Date on which report data was refreshed most recently

  • Scaling factor

  • Further technical information such as add-on version on the Version tab

The following functions are also available in the documentation dialog box:

  • Locked Cells button: for highlighting of cells blocked for data entry

    The blocked cells are marked with a color.

  • Matrix Definition button: for demarcation of the data matrix definition

    All active cells belonging to the matrix definition are highlighted on the worksheet.

  • Insert Data

    You can insert this technical information into the active worksheet at the cursor position.

    Caution Caution

    Only insert technical information into the empty range of a worksheet; otherwise, you can overwrite your processing data.

    End of the caution.

The relevant cells are marked until you choose another function. However, you can print out a copy of the worksheet with this information displayed before you continue.

Origin of Data in a Cell

You can display and, if required, print information about the parameters for the data in a cell. You may want to do this, for example, if you cannot establish the origin of data in a cell from the characteristic values that appear on the worksheet.

If data has been calculated using an Excel formula, the formula is displayed. Data that has been typed directly into the worksheet is identified as a constant.

Activities

To display information about the origin of data, position your cursor on the data in the worksheet and click   SAP Interactive Excel   Origin of data   and then Active Matrix or Cell. Alternatively, you can get information about the origin of data by using the context menu   SAP Interactive Excel   Origin of data  .