Adding dimension attributes to a report

Use this procedure to customize a report by adding dimension attribute columns to a report.

  • GL field attributes are stored in the GeneralLedgerTotal.GeneralLedgerChartAccount dimension and finance dimension 2.
  • Project field attributes are stored in GeneralLedgerTotal.Project and finance dimension 2.
  • Dimension attributes can only be added to posting level row dimensions.
  • Attributes can only be added to one row dimension and are added after the row dimension in the report.
  • The summary level attributes that are not available for selection are Responsible Person, Budget Identifier, and Project team. Report Designer only supports posting level attributes.
  1. Select Row Layout > Dimension Details.
  2. Select a row dimension for the posting level. The Attribute Details section is available. The same attribute details cannot be added to more than one dimension.
  3. Specify the fields for the new attribute for a row dimension.
    Attribute ID
    Select the attribute that is associated with the row dimension.
    Header
    Optionally, edit a column header in the report. The default is from the dimension attribute selected.
    Size
    Define the column size.
  4. Click Save.
  5. Repeat the steps to add more attributes.
  6. To delete a row dimension with attributes or to re-sequence a row dimension, first delete the attribute details that are associated with that row dimension.