Find dimension attribute and value in ax SQL
select a.ASSETID, d.Name, b.DISPLAYVALUE,a.voucher , a.DATAAREAID
from ASSETTRANS as a
join DimensionAttributeValueSetItem as b on a.Defaultdimension = b.DIMENSIONATTRIBUTEVALUESET
join DimensionAttributeValue as c on c.RECID = b.DIMENSIONATTRIBUTEVALUE
join DIMENSIONATTRIBUTE as d on d.recID = c.DimensionAttribute
group by a.ASSETID, d.Name, b.DISPLAYVALUE,a.voucher , a.DATAAREAID
order by ASSETID
