Hi All
How to find the dimensions of a project in sql? In ax 2012 we cant get the projtable dimension value through DIMENSIONATTRIBUTEVALUECOMBINATION relation with projtable with defaultdimension = recid. But the same logic doesn't work in D365. Could you please let me know the tables to find project dimension
Thanks
Sorry DIMENSIONATTRIBUTEVALUESET
Hi Heshu,
Which dimension values are you trying to query? In case you are trying to find the individual dimensions for a particular project, you can try joining with DefaultDimensionView based on ProjTable.DefaultDimension = DefaultDimensionView.DefaultDimension.
Don't we have it as a columns? same like DIMENSIONATTRIBUTEVALUESET. Because I noticed view gives result in row wise . if we couldn't find it then had to pivot the same
Table DIMENSIONATTRIBUTEVALUESET only has the Hash field. It was the same in AX 2012 as well. How were you able to fetch all the dimensions based on this table?
I don't see any table/view that can give you all the dimensions individually. You can however, join the view with a fetch mode 1:1 and can set a range on the Name field for each dimension you are trying to query.
Please let us know the business requirement here as well so that we could suggest a better solution.
ProjTable.DEFAULTDIMENSION = ,DIMENSIONATTRIBUTEVALUESET.RECID
would get dimension columns in AX2012.
Anyway I tried the same query in D365. It gave me the dimensions. I am not sure whether right approach but I got the dimension value as below
select Proj.ProjID,Proj.Name as ProjName,DAVC.BusinessUnitValue,DAVC.companyvalue from projtable Proj,DIMENSIONATTRIBUTEVALUESET DAVC where
Proj.DEFAULTDIMENSION = DAVC.RECID and Proj.dataareaid='001'
and
Proj.projid='00000.0001'
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,047
André Arnaud de Cal... 885 Super User 2025 Season 2
Sohaib Cheema 592 User Group Leader