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 =;
    //It reutrns the value of type DimensionDefault
    return result;

Moreover, if you have more ways to create default dimension, kindly share them in comments.

Github: default dimensions using x++

Do all things with love, passion and dedication! – Patrick Driessen

Share on Facebook
Share on LinkedIn
Share on Twitter
Share on Google+
Share on Skype

The post Create default dimension using x++ appeared first on NevoiTech Blog.