Display method to get financial dimension value

Display method to get financial dimension value:

    public display DimensionValue getBusinessUnit()
    {
        #VKFinancialDimensionNames
        DimensionAttributeValueSetItem  dimensionAttributeValueSetItem;
        DimensionAttributeValue         dimensionAttributeValue;
        DimensionAttribute              dimensionAttribute;
     
        select firstonly DisplayValue from dimensionAttributeValueSetItem
            where dimensionAttributeValueSetItem.DimensionAttributeValueSet == this.DefaultDimension
            join dimensionAttributeValue
                where dimensionAttributeValue.RecId == dimensionAttributeValueSetItem.DimensionAttributeValue
            join dimensionAttribute
                where  dimensionAttribute.RecId     == dimensionAttributeValue.DimensionAttribute
                    && dimensionAttribute.Name      == #FinDimBusinessUnit;

        return dimensionAttributeValueSetItem.DisplayValue;
    }

#FinDimBusinessUnit - replace with name of financial dimension.

 

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units and "buy me a coffee" link.
Join us.

Blog Tags