You’re offline. This is a read only version of the page.
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?
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.
Share
Report
All responses (
Answers (
