How to read dimension combination values !

//Read dimension combination values

These functions used to read the individual ledger dimension combinatio values.

private void getDimensionValues(LedgerDimensionAccount _dimensionRecid)
{
 
    DimensionAttributeLevelValueAllView dimAttrView;
    DimensionAttribute                  dimAttr;


        while select DisplayValue from dimAttrView
            where dimAttrView.ValueCombinationRecId == _dimensionRecid
            join BackingEntityType from dimAttr
                where dimAttr.RecId == dimAttrView.DimensionAttribute
        {
            switch (dimAttr.BackingEntityType)
            {
                case tableNum(DimAttributeMainAccount):
                    info(strFmt(“Main Account: %1″, dimAttrView.DisplayValue));
                    break;
             
                case tableNum(DimAttributeOMBusinessUnit):
                    info(strFmt(“Business Unit: %1″, dimAttrView.DisplayValue));
                    break;

                case tableNum(DimAttributeCustTable):
                    info(strFmt(“Customer: %1″, dimAttrView.DisplayValue));
                    break;

                case tableNum(DimAttributeOMDepartment):
                    info(strFmt(“Department: %1″, dimAttrView.DisplayValue));
                    break;

                case tableNum(DimAttributeHcmWorker):
                    info(strFmt(“Worker: %1″, dimAttrView.DisplayValue));
                    break;
            }
        }
 
 
}

private DimensionValue getDimensionValueByName (LedgerDimensionAccount _dimensionRecid, Name _name)
{
    DimensionAttributeLevelValueAllView dimAttrView;
    DimensionAttribute                  dimAttr;

 
        Select DisplayValue from dimAttrView
            where dimAttrView.ValueCombinationRecId == _dimensionRecid
            join BackingEntityType from dimAttr
                where dimAttr.RecId == dimAttrView.DimensionAttribute
  && dimattr.Name==_name;


return dimAttrView.DisplayValue;

}
----------------------------------------------------------------------------------------------------------------

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  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));
}

-----------------------------------------------------------------------------------------------------------------