Setting Financial Dimension Values in AX 2012

Jun 18, 2014 | Posted by Becky Newell | Development, Dynamics AX |

In AX 2012 you can set the value for a specific dimension using code similar to what is below.

DimensionAttributeValue         dimAttrValue;
DimensionAttribute              dimAttr;
DimensionAttributeValueSetStorage davss;
RecId                defaultDimension;

davss = DimensionAttributeValueSetStorage::find(this.DefaultDimension);

dimAttr = DimensionAttribute::findByName(‘MyDimensionName’);
dimAttrValue = DimensionAttributeValue::findByDimensionAttributeAndValue(dimAttr, “DimensionValue”, false, true);
if(dimAttrValue)
{
davss.addItem(dimAttrValue);
this.DefaultDimension = davss.save();
}

About Becky Newell

Becky is a co-founder of Stoneridge Software and the President of Levridge, a subsidiary of Stoneridge Software. She has expertise in X++, .NET, Enterprise Portal, and reporting development. She is a 14-year veteran of Microsoft, where she provided support to partners and ISV development teams. She has trained many development teams and is a consistent trainer at Microsoft's Fast TrAX Academy, AX user groups and Stoneridge online training courses.

3 Comments

Leave your reply.

saveriot

January 2, 2018 at 8:48 AM

dimAttrValue seems to be always true.
Taylor Valnes

January 10, 2018 at 9:36 AM

Hello!

There can be instances where the value isn’t found (dimAttr is a table buffer, so if a record isn’t found, this will be false), so at that point, an else statement could be used to set a predefined value if desired.
dimAttr = DimensionAttribute::findByName(‘MyDimensionName’);
The above line is looking for a record in the table. The code example simply doesn’t have an else condition to do something if a record is not found in the table.

Regards,
Taylor