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 Column Views tab, select a column view record.
  3. In the Column List section, click Create.
  4. In the Column Type field, select Standard.
  5. Specify this information:
    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.
    Offset Padding
    Specify the number of additional spaces to include between columns. 
    ​​
    Number of Decimals
    Specify the number of decimals for amount values.
    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 Column Views tab, select a Column View and navigate to the Associated Reports tab to show reports associated with column views.