Mapping Models
This topic describes how to map a model for models data.
Procedure
- Map the id source column to the Technical ID card.
- Create a measure source column and adjust the mapping for the Measure attribute card:
- 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.
- Double-click the Measure card.
- Map the calculated column to the attribute card.
- Unmap the source column for the Category card.
- (Only relevant if the source column for the long description has more than 256 characters) limit the long description to the first 255 characters:
- Create a calculated column called Long Description Truncated and add the formula SUBSTRING ([longDescription], 0, 256) to it.
- Unmap the source column for the Long Description card.
- Map the new calculated column to the Long Description card.