Creating standard columns

A standard column displays a specific value and its operators. A standard column is not calculated. You can add dimension filters to limit the data that is displayed in the column.

  1. Select My Reports > Report Designer.
  2. On the Columns tab, select a column record.
  3. In the Column Details section, click Create.
  4. In the Column Type field, select Standard.
  5. Specify this information:
    Column Name
    Specify a name to the column header.
    Column Value
    Select the measure to use for the column value. If additional period operators are required, then click Add Operator To Field.

    See Adding period operators.

    Note: If additional period operators are not required select a measure from the list and select Ok.
    Column Name
    Specify a label for the column header.
    Column Size
    Add a column width.
    Offset Padding
    Specify the number of additional spaces to include between columns. 
    ​​
    Number of Decimals
    Specify the number of decimals for amount values.
    Alt Column Name
    Override the column name on a report by entering an alternate column name.
    Show Column On Report
    Clear this check box to omit the column from the report.
    Show Column Header
    Clear this check box to hide the column heading.
    Show As Percentage
    Select this check box to show amount values as percentages.
    Suppress Commas
    Select this check box to omit commas in amount values.
  6. Click Save.
  7. In the Dimension Filters section, click Create.
  8. Select a Dimension.
  9. Click Save.
  10. Click Add Dimension Filter. You must add a Scenario Column Dimension Filter or Generate Report and the Run Report option will not be available. The other Column Dimension Filters are optional. Additionally, if users opted to add other Column Dimension Filters, it must have a value or else the Generate Report and Run Report will not be available.
  11. Select a filter value. For some dimensions, you must select a structure and an element within the structure.
  12. Click Submit.
    Optionally, select the Columns tab, select a Column and navigate to the Associated Reports tab to show reports associated with columns.