Thursday, January 21, 2016

Ledegr dimension Value Ax 2012

static void LedgerDimValues(Args _args)
 {
     DimensionAttributeLevelValueAllView dimAttrView;
     DimensionAttribute dimAttr;
     ;
     while select DisplayValue from dimAttrView
            where dimAttrView.ValueCombinationRecId == 5637164076 //Ledger Dimension
        join BackingEntityType from dimAttr
            where dimAttr.RecId == dimAttrView.DimensionAttribute           
            && dimAttr.Name == "Employees" // Dimension name
     {
        info(strFmt("%1 - %2",dimAttr.Name, dimAttrView.DisplayValue));
     }
 }

No comments:

Post a Comment

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...