You’re offline. This is a read only version of the page.
I am using D365's export to data lake feature and then using CDMUtil to make this data available for querying. I exported the entity FinancialDimensionValueEntity which comprises of 3 underlying tables:
The entity JSON file has the following SQL definition in it:
CREATE VIEW [DBO].[FINANCIALDIMENSIONVALUEENTITY] AS SELECT T1.DIMENSIONATTRIBUTE AS FINANCIALDIMENSION, T1.LEGALENTITYID AS LEGALENTITYID, T1.DIMENSIONVALUE AS DIMENSIONVALUE, T1.DESCRIPTION AS DESCRIPTION, T1.ACTIVEFROM AS ACTIVEFROM, T1.ACTIVETO AS ACTIVETO, T1.ISSUSPENDED AS ISSUSPENDED, T1.ISTOTAL AS ISTOTAL, T1.ISBLOCKEDFORMANUALENTRY AS ISBLOCKEDFORMANUALENTRY, T1.GROUPDIMENSION AS GROUPDIMENSION, T1.PARTITION AS PARTITION, T1.RECID AS RECID, T2.ISBALANCING_PSN AS ISBALANCING_PSN, T2.OWNER AS OWNERREFRECID, T2.RECVERSION AS RECVERSION#2, T2.PARTITION AS PARTITION#2, T2.RECID AS RECID#2, T3.PERSONNELNUMBER AS OWNER, T3.RECVERSION AS RECVERSION#3, T3.PARTITION AS PARTITION#3, T3.RECID AS RECID#3 FROM FINANCIALDIMENSIONVALUEENTITYVIEW T1 LEFT OUTER JOIN DIMENSIONATTRIBUTEVALUE T2 ON(( T1.DIMENSIONATTRIBUTEVALUE = T2.RECID) AND ( T1.PARTITION = T2.PARTITION)) LEFT OUTER JOIN HCMWORKER T3 ON(( T2.OWNER = T3.RECID) AND ( T2.PARTITION = T3.PARTITION)) WHERE(((((((( T1.DIMENSIONATTRIBUTETYPE = 0) OR ( T1.DIMENSIONATTRIBUTETYPE = 1)) OR ( T1.ACTIVEFROM <> 0)) OR ( T1.ACTIVETO <> 0)) OR ( T1.ISSUSPENDED <> 0)) OR ( T1.ISTOTAL <> 0)) OR ( T1.ISBLOCKEDFORMANUALENTRY <> 0)) OR ( T1.GROUPDIMENSION <> N''))
The above SQL selects from FINANCIALDIMENSIONVALUEENTITYVIEW which is not one of the underlying tables. Further along in the JSON it confirms the dependency:
Share
Report /name/: /backingElements/, /value/: /FinancialDimensionValueEntityView,DimensionAttributeValue,HcmWorker/How do I figure out the definition for FinancialDimensionValueEntityView so that I can create this view in Synapse?
I have tried finding the underlying view definition without success. I have tried finding a matching entity in D365 but could not identify one.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (