Overriding Row and Column Headings for Grids

Defining row and column headings enables you to override the heading properties you set for the grid. You can specify one of the following types of headings for rows or columns:

Member Labels
- The member name, which displays the member name as the heading.
- The alias or description, which displays the alias or description as the heading.
- The member name and alias or description, which displays the member name and alias or description as the heading.
Custom Headings
- Customized text, which displays the user-defined text as the heading.
- Text functions, which uses a text function to get data to display as the heading.

You can also suppress headings for repeating members in a segment. When you suppress headings, only the first instance of the heading for a member that is repeated is displayed. Headings for the additional repeating members are hidden.

To override row and column headings for the grid:

Open a report and a formula row or column in the grid.

Do one of the following tasks:

Select Member Labels and then select one of the following member labels options:

Member Name, to display the member name as the heading.
Alias:Default, to display an alias for a member from an Oracle Essbase or Planning Details database connection OR Description, to display a description for a member from a Financial Management database connection.

Both, to display the member name and alias or description as the heading.

Note:

The option that is displayed on the Properties sheet changes depending on your database connection. For example, if you are using Financial Management as your database connection, the Description option is displayed. In this case, the Alias:Default option is not displayed.

Select Custom Heading and then do one or both of the following tasks:
- Enter a user-defined text heading to be displayed as the heading.
  Tip:
  You can enter keyboard returns to create text headings for columns with multiple lines.
- Enter a text function, or click the Insert Function button, and select the text function you want to use for displaying data on the headings.
  Note:
  You must select the entire row or column to display the Suppress Repeats option in the Row and Column property sheets.

Optional: Select the Short Name for Entities check box to display the short name for entities in your Financial Management grid.