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 Layout 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.
    Insert Row Dimension After This Column
    Optionally, select this check box if a row dimension should be inserted after one column.
    Note: This option can only be applied to one column.
    Format Header
    Optionally, select this check box to turn on the options to format the column header then specify the necessary information in the Header Text Alignment, Bold, and Italics fields.
    Header Text Alignment
    Select the alignment needed for the column header. The options are Left, Center, and Right.
    Bold
    Select this check box for the column header to have bold font.
    Italics
    Select this check box for the column header to have italicized font.
  6. Click Save.
  7. In the Dimension Filters section, click Create.
  8. Select a Dimension.
  9. Click Save.
  10. Click Add Dimension Filter or Add Budget Parameter. You must add a Scenario Column Dimension Filter or Budget Parameter 1 or 2. Otherwise, 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.
    Note: Add Budget Parameter allows a budget to be selected for the column during Set Preview Parameters or Run Report.
  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 Layout tab, select a Column and navigate to the Associated Reports tab to show reports associated with columns.