web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

SQL D365 Query

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: SQL D365 Query

    Sorry DIMENSIONATTRIBUTEVALUESET

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at
    RE: SQL D365 Query

    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.

  • Community Member Profile Picture
    on at
    RE: SQL D365 Query

    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

  • Gunjan Bhattachayya Profile Picture
    35,423 on at
    RE: SQL D365 Query

    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.

  • Verified answer
    Community Member Profile Picture
    on at
    RE: SQL D365 Query

    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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans