Showing posts with label Split. Show all posts
Showing posts with label Split. Show all posts

Thursday, April 11, 2019

AX 2012 Split Default Dimension to get Department

Public display Description Department()
{

    
    Name dimensionAttributeName;
    RecId DepartmentAttribute;
    DefaultDimensionView dimensionView;
    DimensionAttribute dimensionAttribute;
    DimensionAttribute      dimAttribute;

    dimensionAttributeName = "Department";
    DepartmentAttribute = DimensionAttribute::findByName('Department').RecId;
    

            select firstOnly dimensionView
            where dimensionView.DefaultDimension == this.DefaultDimension

            join dimensionAttribute
            where dimensionView.Name == dimensionAttribute.Name &&
            dimensionView.Name == dimensionAttributeName;
            dimAttribute = DimensionAttribute::find(dimensionView.DimensionAttributeId);
    return DimensionFinancialTag::findByFinancialTagCategoryAndValue(dimAttribute.financialTagCategory(), dimensionView.DisplayValue).Description;
}