dim2mea Parameters

When you define a dim2mea transformation, you set the action attribute to dim2mea and specify the parameters.

The following table describes the input parameters:

Parameter	Required?	Value
dimension	Yes	Dimension column in the dataset from which you want to create the measure.
measure	Yes	Name of the output measure. This column name must be unique within the dataset. Do not use the same name as the dimension because the transformation preserves the dimension in the dataset. The measure name is also the new field's API name, so it: Can contain only alphanumeric and underscore characters. Must begin with a letter. Can’t end with an underscore. Can’t contain 2 consecutive underscore characters, except when ending with “__c” (case-sensitive).
measureDefault	Yes	Default value for the measure if the transformation is unable to create a measure from a dimension.
measureType	Yes	Type of measure. Valid value: “long”
source	Yes	Node in the dataflow definition file that contains the dataset to which you want to add the measure.