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

(1) Share

Report

Posted on by Superbunny

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.

All responses (7)

Answers (3)

Superbunny 160 on at

Like (0)

Report

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 230,445 Most Valuable Professional on at

Like (0)

Report

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 160 on at

Like (0)

Report

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 56 on at

Like (0)

Report

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'.

Look here: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/financial/dimension-defaulting#:~:text=Storage%20of%20default%20dimension%20values,that%20references%20those%20dimension%20values.

Kind regards,

Maris
Verified answer

Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

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 160 on at

Like (0)

Report

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 27,832 Super User 2024 Season 1 on at

Like (1)

Report

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.