Row Code in Management Reporter

The numbers or labels in the Row Code cell identify each line in the row definition. Calculations and totals identify the data to operate on by referring to the row codes.

A row code is required for each row that is referred to by other rows. You can mix numeric, alphanumeric, and unset (empty) row codes within a row definition.

The row code can be any positive integer or a descriptive label that identifies that row. A descriptive label must adhere to the following rules:

  • A label can be any combination of numbers and letters up to 16 characters.

  • A label must begin with an alphabetical character (a-z or A-Z).

  • A label can use the underscore (_) character, but no other special characters can be used.

  • A label cannot be any of the following reserved words: AND, OR, IF, THEN, ELSE, PERIODS, TO, CBR, UNIT, NULL, CPO, RPO.

Examples of valid row codes include:

  • 320

  • TL_NET_INCOME

  • TL_NET_94

You can reset the numeric row codes to equally spaced values. Microsoft Office PerformancePoint 2007 Management Reporter renumbers row codes that begin with numbers (for example, 130, 246), but does not renumber row codes that begin with letters (for example, INCOME_93, TP0693).

To set a row code, do the following:

  • Type the new value into the cell in the Row Code column.

To reset numeric row codes, do the following:

  1. On the Edit menu, click Renumber Rows.

  2. Specify the new values for starting row code and row code increment.

    Note: When you renumber row codes, Management Reporter automatically updates TOT and CAL references. For example, if a TOT row references a range that starts with row code 100, and you renumber starting with 90, the starting TOT reference changes to from 100 to 90.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×