Adding a Table

Add a table to a report to retrieve data from a Cloud EPM relational schema (Enterprise licenses only).

To add a table to a report:

  1. Do one of the following:
    • From the toolbar, click Add and select Table.
    • From a blank report, click add table icon.
  2. Click Setup Table.
  3. In Select Source, select a schema for the table.

Note:

For more information on the available table sources, see Overview in Cloud EPM System Reporting Schema Reference Guide .

The table is displayed in Table Designer with a single data row and an attribute column. You can add more data columns, formulas, text, and separator rows. You cannot insert additional data rows in a table, however you can insert additional formulas, text, and separator rows.

When you add a new table, the system assigns a default name to the table. The default name assigned is Table n, where n is a system-assigned identification number. For example, if you save a table that is the sixth system-named table saved in the report, the default name is Table 6. You can rename the table in Table Properties.

The system uses the table name when a function or chart references the table. For example, if you design a chart to graphically display the data from a table, the chart properties must reference the table by its name.