Mapping Models

This topic describes how to map a model for models data.

Procedure

  1. Map the id source column to the Technical ID card.
  2. Create a measure source column and adjust the mapping for the Measure attribute card:
    1. Create a calculated column and add a fixed value as the formula, for example, 1. For more information about creating calculated columns, see Video: Create Calculated Columns.
    2. Double-click the Measure card.
    3. Map the calculated column to the attribute card.
  3. Unmap the source column for the Category card.
  4. (Only relevant if the source column for the long description has more than 256 characters) limit the long description to the first 255 characters:
    1. Create a calculated column called Long Description Truncated and add the formula SUBSTRING ([longDescription], 0, 256) to it.
    2. Unmap the source column for the Long Description card.
    3. Map the new calculated column to the Long Description card.

Results

The mapping is adjusted.