Dimensions can be configured to include labels and have the default label field set. They can also have group totals defined. Once this has been done, the dimension can be saved to a dimension definition file. This can be done in one of the following ways:

Once the dimension definition file exists, it can be associated with a source field so that when you drag the source field into the table, the labels are brought into the table as well. To associated a source field with a dimension definition file, you must create a source field summary.


Creating a Source Field Summary

A source field summary can be defined at any time before you begin creating a table or an extract.

The Source Field Summary editor enables you to do the following:

  • Enter a field description and category for the source field to assist Browser users in locating the field.
  • Enter a dimension definition file for the Builder to use when creating the source field.
  • Modify the field treatment.
  • Specify the data frequency and format for date fields.
  • Redefine or confirm a field's type and position.

To define a source field summary:

  1. Do one of the following:
    • Right-click on the source field you want to add a summary to. Choose Source Field Summary.
    • From the Data menu, choose Source Field Summary.
    • From the Source menu, choose Define Source Fields, highlight a field in the Field Name area, and then click Summary.

  2. The Source Field Summary editor appears:

  3. If you want to use an existing dimension definition file, type the full path and file name in the Definition File area, or else click Browse to locate and select the file. The description and category from the dimension file appear dimmed in the dialog box. Proceed to Step 5.

    Note: To create a dimension definition file, see Creating and Saving a Dimension Definition File, https://beyond2020.freshdesk.com/a/solutions/articles/44002126471.

  4. In Field Description, enter a description for the field.
  5. In Category, enter a subject area classification for the field.

    Note: This area is only used when creating an extract.

  6. If you want to change the way the field should be treated during the creation of an extract, select the appropriate option in the Treatment area. (If you select Date Field, you must also select the data frequency.)
  7. If you want to change the type of the field, select the new type in the Field Datatype area. (If you select Date, you must also select the corresponding date format.)

    Note: You cannot change the Field Datatype of a CSV file.

  8. Click OK.

See Also