---
schema_version: "1"
id: 220e7cabbd8f29320d22466106d0b13905c511805bb81b80985c50dc7285d351
title: dim2mea Parameters
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_dim2mea_transformation_operation.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dim2mea_transformation_operation.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 32a62505072b4d218a0ff0d789e2ac7571f0c59bdc1717b2556aa7250b555921
description: When you define a dim2mea transformation, you set the action attribute to dim2mea and specify the parameters.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# 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:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23375e44">Parameter</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23375e47">Required?</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23375e50">Value</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e44 ">dimension</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e50 ">Dimension column in the dataset from which you want to create the
              measure.</td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e44 ">measure</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e50 ">
              <p>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.</p>
              <p>The measure name is also the new field's API name, so it:</p>
              <ul>
                <li>Can contain only alphanumeric and underscore characters.</li>
                <li>Must begin with a letter.</li>
                <li>Can’t end with an underscore.</li>
                <li>Can’t contain 2 consecutive underscore characters, except when ending with
                  “__c” (case-sensitive).</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e44 ">measureDefault</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e50 ">Default value for the measure if the transformation is unable to create a
              measure from a dimension.</td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e44 ">measureType</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e50 ">Type of measure. Valid value: “long”</td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e44 ">source</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23375e50 ">Node in the dataflow definition file that contains the dataset to which you
              want to add the measure.</td>

          </tr>
        </tbody>
      </table>

#### See Also

- [dim2mea Transformation](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dim2mea_transformation.htm&release=264.0.0&type=5 "The dim2mea Transformation creates a new measure based on a dimension. The transformation adds the new measure column to the dataset. The transformation also preserves the dimension to ensure that lenses and dashboards don’t break if they use the dimension.")