Search This Blog

Thursday, February 14, 2013

Ax2012 get the Dimension description and display value


This job is used to get the dimension value and description for the specific dimension record.

static void  Krishh_GetDimensionAttributeDesc(Args _args)
{
    DimensionAttributeValueSetItemView  dimAttrsetView;
    DimensionAttribute                  dimensionattr;
    DimensionFinancialTag               dimensionfinancialtag;
    refrecid  financialTagCategory;
    ;

    select dimAttrsetView
    where dimAttrsetView.DimensionAttributeValueSet ==5637149326
    join dimensionattr
    where dimensionattr.RecId == dimAttrsetView.DimensionAttribute
        &&
    dimensionattr.Name == "SAPProductCode";

    financialTagCategory=dimensionattr.financialTagCategory();

    select  dimensionfinancialtag
    where dimensionfinancialtag.FinancialTagCategory == financialTagCategory;

    info(dimAttrsetView.DisplayValue);
   or
   info(strfmt("Display value= %1",dimensionfinancialtag.value));
    info(strfmt("Descriprition %1",dimensionfinancialtag.Description));
}

1 comment:

  1. thanks for the method, I was able to show the value of the financial dimension

    ReplyDelete

Thanks for visiting my blog,
I will reply for your comment within 48 hours.

Thanks,
krishna.