D365FFO – AX – Create default dimension using x++

Default dimensions are used very commonly in D365FO and DAX 2012. During development or customization of the system, it is very common that we often stuck at the time when we have to create default dimension using our own dimension values. To solve this problem, I am sharing this code. You just have to alter dimension names, values, arguments and no. of arguments.

Note: I am using three arguments, inserting values to three dimensions and getting DimensionDefault value for it. You can do this for one dimension or as many dimensions as you want.

//Change the arguments (variable) names and assign names as per your requirements
//Change in the function as well
public DimensionDefault createDefaultDimension(str department, str purpose, str costCenter)
    DimensionAttributeValueSetStorage   valueSetStorage = new DimensionAttributeValueSetStorage();
    DimensionDefault                    result;
    int                     i;
    DimensionAttribute      dimensionAttribute;
    DimensionAttributeValue dimensionAttributeValue;
    //Change the dimension names. Use the dimension name which are open and active in the system
    //I have given Region, Purpose and Costcentre just for an example
    container               conAttr = ["Region", "Purpose", "Costcentre"];
    //Change the values which you want to set in dimensions. Use values which are open and active in the system
    //I have given the arguments of function as values for dimensions.
    //Dimension name    ->      dimension value
    //Region            ->      department
    //Purpose           ->      purpose
    //Costcentre        ->      costCenter
    container               conValue = [department, purpose, costCenter];
    str                     dimValue;
    for (i = 1; i <= conLen(conAttr); i++)
        dimensionAttribute = dimensionAttribute::findByName(conPeek(conAttr,i));
        if (dimensionAttribute.RecId == 0)
        dimValue = conPeek(conValue,i);
        if (dimValue != "")
            dimensionAttributeValue = dimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,dimValue,false,true);
    result = valueSetStorage.save();
    //It reutrns the value of type DimensionDefault
    return result;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s