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
    Add 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 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 at least one filter.
  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.