web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / D365/AX by Pedro Tornich / Get Dimension Value From De...

Get Dimension Value From Default Dimension

Pedro Tornich Profile Picture Pedro Tornich 955
static void getDimensionValueFromDefaultDimension(Args _args)
{
    #define.DimensionName('MyCustomDim')
    DimensionAttributeValueSetItem dimAttrValueSetItem;
    DimensionAttributeValue dimAttrValue;
    DimensionAttribute dimAttr = DimensionAttribute::findByName(#DimensionName);

    str dimensionValue;
    ProjTable projTable;

    projTable = ProjTable::find('DummyProjId');

    select firstOnly DisplayValue from dimAttrValueSetItem
        where dimAttrValueSetItem.DimensionAttributeValueSet == projTable.DefaultDimension
        exists join dimAttrValue
            where dimAttrValue.RecId == dimAttrValueSetItem.DimensionAttributeValue
            && dimAttrValue.DimensionAttribute == dimAttr.RecId;

    dimensionValue = dimAttrValueSetItem.DisplayValue;

    info(dimensionValue);
}

This was originally posted here.

Comments

*This post is locked for comments