DimensionAttributeValueCombination relationship with other table

(0) Share

Report

Posted on by gg96

120

I have the following SQL query where Im getting the display value and group dimension data.

SELECT DISTINCT DAVS.RECID, DAVSI.DisplayValue, GroupDimension /*= ISNULL(GroupDimension, '') */
FROM D365.DimensionAttributeValueSet DAVS
INNER JOIN D365.DimensionAttributeValueSetItem DAVSI ON DAVS.RECID = DAVSI.DIMENSIONATTRIBUTEVALUESET AND DAVS.PARTITION = DAVSI.PARTITION
INNER JOIN D365.DimensionAttributeValue DAV ON DAVSI.DIMENSIONATTRIBUTEVALUE = DAV.RECID AND DAVSI.PARTITION = DAV.PARTITION
INNER JOIN D365.DimensionAttribute DA ON DAV.DIMENSIONATTRIBUTE = DA.RECID AND DAV.PARTITION = DA.PARTITION
WHERE [Name] = 'Producttype'

But I would like to also add one more INNER join with DimensionAttributeValueCombination table but Im having hard time to find a relationship with other tables.

How can I join?

I have the same question (0)

All responses (1)

Answers (0)

André Arnaud de Cal... 303,247 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi gg96,

Can you explain the required outcome of your SQL statement? What is the business requirement?

Note that there are views in the database which could make your life easier as they already have different tables joined to get dimension values. Check if there is one which could be used for your requirement.

Was this reply helpful? Yes No