Get display value from Ledger Dimension

 DimensionAttributeLevelValueAllView dimAttrView;

        DimensionAttribute                  dimAttr;

select DisplayValue from dimAttrView where dimAttrView.ValueCombinationRecId ==   _LedgerDimension

              join dimAttr

                  where dimAttr.RecId == dimAttrView.DimensionAttribute

                  && dimAttr.Name == "Department";

        _Department = dimAttrView.DisplayValue;