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.

Support The Author

 If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.

Buy Me a Coffee

Post a Comment

   renew the code

All Comments

No comments. Be the first one to comment on this post.

Search

About

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

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

Blog Tags