select c.NAME,a.DISPLAYVALUE from DIMENSIONATTRIBUTEVALUESETITEM a
INNER JOIN DIMENSIONATTRIBUTEVALUE b on a.DIMENSIONATTRIBUTEVALUE = b.RECID
INNER JOIN DIMENSIONATTRIBUTE c on b.DIMENSIONATTRIBUTE = c.RECID
where a.DIMENSIONATTRIBUTEVALUESET= <DEFAULT DIMENSION RECID>
Advertisements
