Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Where are my chosen values for financial dimensions saved in the database?

(1) ShareShare
ReportReport
Posted on by 160
I want to find where the values for financial dimensions of a project are stored.
 
When I go to the form 'ProjTable' I can see a financial tab, which contains a 'DimensionEntryControl'. 
I cannot however find how projectdata gets loaded into and from this formcontrol
 
I also checked the tables used on this form and I did find the DimensionAttributeValueSet, which contains the defaultfinancialdimension.
This field is filled however when a  project is created.
I want to find the actual place in the database where the project's chosen business unit is stored.
 
 
  • Superbunny Profile Picture
    Superbunny 160 on at
    Where are my chosen values for financial dimensions saved in the database?
    Hey all,
     
    yes, I see it now! I managed to grab the values. Thanks a lot all for the patient explanations!
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    Where are my chosen values for financial dimensions saved in the database?
    We got it. DefaultDimension is populated (with a record ID of a dimension combination); checking whether it's filled in or not would be indeed useless. You're interested in an individual dimension, therefore you need some code getting the value of this dimension from the value of DefaultDimension field. And that's what we answered below.
     
    By the way, this thread was created by Kai Janssen but now it's Superbunny who continues the discussion. Are those two accounts of the same person?
  • Superbunny Profile Picture
    Superbunny 160 on at
    Where are my chosen values for financial dimensions saved in the database?
    Hey all,
     
    It seems it is not understood what exactly I want to do.
    I wish to extend the validateWrite method of the projTable. 
     
    In there I want to throw an error if no business unit has been entered by the user.
     
    So I will need to check the projects'  business unit. 
     
    This is NOT the field defaultdimension. I can verify this simply by creating a new project in d365 and then seeing that no business unit has been assigned.
    In the database however, the defaultdimension field for this project is of course filled.
     
    So how could I check whether a business unit has been added to a project via the GUI?
  • Suggested answer
    Maris Sausins Profile Picture
    Maris Sausins 56 on at
    Where are my chosen values for financial dimensions saved in the database?
    Hello, Kai!
     
    GirishS already explained, but I wanted to add that you can get to values using 'DimensionAttibuteValueSetItemView'. 
     
     
    Kind regards,
    Maris
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    Where are my chosen values for financial dimensions saved in the database?
    Don't try to work with the tables directly; the data model is very complex. Instead, use existing tables and/or views that simplify the work. I suggest DimensionAttributeValueSetStorage class.
  • Superbunny Profile Picture
    Superbunny 160 on at
    Where are my chosen values for financial dimensions saved in the database?
    Hey GirishS,
     
    Thank you for the info.
     
    The problem I am having is that I want to perform logic when changing a projectstage. The logic will basically be throwing an error if no business unit has been selected for the project.
     
    So in order to check if the user has entered a business unit, I need that actual field belonging to the report. (the defaultdimension is always filled, so I can not use this field to assert whether a user assigned a business unit or not)
  • Verified answer
    GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    Where are my chosen values for financial dimensions saved in the database?
    Hi Kai,
     
    You can refer to the DimensionAttributeValueSetItem table - This table will have all the financial dimension details.
    Inside ProjTable there will be one field called DefaultDimension - Based on this field values you will get financial dimensions from DimensionAttributeValue, DimensionAttributeValueSet and DimensionAttributeValueSetItem.
     
    Thanks,
    Girish S.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans