1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Working with Grids
  3. Adding a Grid
  4. About Grid Properties
  5. Overview of Grid Properties

Overview of Grid Properties

The following grid properties are available in the Properties panel while editing a grid:

general properties iconGeneral Properties

General properties affect the entire grid. Use general properties to edit some of the following types of items:

  • View or change the grid’s data source

  • Set a title to be displayed above the grid

  • Define the default grid behaviors for row and column sizing, row banding, zoom and drill to source.

  • Set the member heading properties

  • Define the text replacement labels for zero, missing and error data cells

  • Enable suppression

For more information, see General Properties.

column properties iconColumn Properties

Column properties affect an entire column. You must click in a column header to select the column that you want to view the properties for. Use column properties to override the default grid settings for column width, repeated headings, and suppression settings.

For more information, see Column Properties

row properties iconRow Properties

Row properties affect an entire row. You must click in a row header to select the row that you want to view the properties for. Use row properties to override the default grid settings for row height, repeated headings, and suppression settings.

For more information, see Row Properties

cell properties iconCell Properties

Cell properties affect the selected range of cells in a grid. Use cell properties to change the way cell text is formatted. For example, you can change the way positive and negative numbers are displayed, and you can change the font, color, and size of text within a cell. You can add borders or shading to a cell range, and specify zoom and indent options. You can also show or hide cell attachment links for selected cells in the grid that have attachments at the data source. See Formatting Grid Cells.

sorting iconSorting

You can sort values in a grid. You can add multiple sorts (for example, you can sort by columns and then by rows), and you can add multiple rows or columns to a sort (for example, sort columns by column members, and then by row 3).

For more information, see Sorting

conditional format icon Conditional Properties

Conditional formatting, text and suppression enables you to define formatting, text or suppress cells in a grid that meet conditions that you define. See Working with Conditional Formatting, Text, and Suppression

drill to icon Drill Through

Drill through properties allow you to set up content links on grid data cells, rows, columns, and member header cells. See Working with Drill To Content.