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.