1. User's Guide
  2. Working With Grids
  3. Working With Rows and Columns in Grids
  4. Defining Row and Column Headings

Defining Row and Column Headings

To define row and column headings for a grid:

  1. In an existing grid, select the cell in the upper left corner of the grid.
  2. In Grid Properties, under the Headings section, define the following information about the heading:

    • In Member Labels, select what to display in the heading (Member Name, Alias, or Both).

    • In Row Headings Before, select a column.

      The row heading is positioned to the left of the selected column. Columns are represented alphabetically as Column A, Column B, Column C, and so on. You cannot place row headings before columns that are sorted.

    • Select Suppress Repeats to hide headings for repeating members in a segment.

      When you suppress repeats, only the first instance of the heading for a repeated member is displayed. Headings for additional repeating members are hidden.

    • In Alias Table, select the alias table to use when showing aliases.

      You can select alias tables in your database connection. Although you cannot specify aliases at the grid level, if you display aliases for a row or column, the system displays the alias table as selected at the grid level. The alias table is initially set to the default alias table for the database connection type.

Note:

The heading properties you define apply to all rows and columns unless you specify otherwise.

If you are using the Entity dimension through a Oracle Hyperion Financial Management database connection, you can select the check box for Short Name for Entities for the row, column, or grid using the relevant properties sheet. This option enables you to display the short name of the entity in your report, removing the parent portion of the entity that typically displays.

The standard display for an entity using Financial Management is "parent.child." If you select Short Name for Entities on the relevant properties sheet, the entity displays as "child," removing the "parent" from the display. For example, an entity that typically displays as "UnitedStates.Connecticut" displays as "Connecticut" when the Short Name for Entities check box is selected.