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

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...