Query to Find specific attribute from DimensionAttributeValueCombination

SELECT * FROM DIMENSIONATTRIBUTEVALUECOMBINATION
WHERE RECID = 5637145399
SELECT DBO.GETVALUEFROMDEFAULTDIMENSION(5637148356, ‘BUSINESSUNIT’)
SELECT DBO.GETVALUEFROMLEDGERDIMENSION(5637145399, ‘MAINACCOUNT’)
GO
ALTER FUNCTION GETVALUEFROMLEDGERDIMENSION(
@DEFAULTDIMENSION BIGINT,
@BACKINGENTITYTYPE VARCHAR(50)
)
RETURNS VARCHAR(50)
AS
BEGIN
DECLARE @DIMENSIONVALUE VARCHAR(50);

SELECT @DIMENSIONVALUE = DISPLAYVALUE
FROM DIMENSIONATTRIBUTE DA
JOIN DIMENSIONATTRIBUTEVALUE DAV ON DA.RECID = DAV.DIMENSIONATTRIBUTE
JOIN DIMENSIONATTRIBUTELEVELVALUE DALV ON DALV.DIMENSIONATTRIBUTEVALUE = DAV.RECID
JOIN DIMENSIONATTRIBUTEVALUEGROUPCOMBINATION DAVG ON DAVG.DIMENSIONATTRIBUTEVALUEGROUP = DALV.DIMENSIONATTRIBUTEVALUEGROUP
WHERE DA.NAME = @BACKINGENTITYTYPE AND DAVG.RECID = @DEFAULTDIMENSION

RETURN(@DIMENSIONVALUE);
END;
GO
ALTER FUNCTION GETVALUEFROMDEFAULTDIMENSION(
@DEFAULTDIMENSION BIGINT,
@BACKINGENTITYTYPE VARCHAR(50)
)
RETURNS VARCHAR(50)
AS
BEGIN
DECLARE @DIMENSIONVALUE VARCHAR(50);

SELECT @DIMENSIONVALUE = DAVSI.DISPLAYVALUE
FROM DIMENSIONATTRIBUTE DA
JOIN DIMENSIONATTRIBUTEVALUE DAV ON DAV.DIMENSIONATTRIBUTE = DA.RECID
JOIN DIMENSIONATTRIBUTEVALUESETITEM DAVSI ON DAVSI.DIMENSIONATTRIBUTEVALUE = DAV.RECID
WHERE DA.NAME = @BACKINGENTITYTYPE AND DAVSI.DIMENSIONATTRIBUTEVALUESET= @DEFAULTDIMENSION

RETURN(@DIMENSIONVALUE);
END;