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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / DefaultDimensionView d...
Microsoft Dynamics AX (Archived)

DefaultDimensionView does not return Dimension values that got created from UI

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I created a Dimension Attribute 'Product Category' from GL-> Chart Of accounts -> Dimensions->Financial Dimension 

and I added few dimension values for it by clicking  'Dimension Value' button at the top.

When i run the view DEFAULTDIMENSIONVIEW , it doesn't return this new dimension values I added.

I found the root cause that the table DIMENSIONATTRIBUTEVALUESETITEM does not contain the dimension value I added and hence the problem.

But I don't know why this is happening in the first place. What am I missing here? There are no any customizations around it.

Can someone please help to understand this problem?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    Hi VDY.

    Just note that the values will only appear in the view and tables mentioned once they have actually been selected by a document (as part of a dimension selection). E.G. On a PR, journal, PO etc.

    Before this they will only be available in DimensionAttributeValue table

  • Community Member Profile Picture
    Community Member on at

    Correct. Here the thing is, values haven't yet selected  anywhere. They've been recently created. They are being used in the import feature which we newly developed as part of customization.  

    The import file has only Dimension Description in lines and we are trying to find Display value out of it and then ultimately DefaultDimension from it. But we get Display Value blank and hence we can't see it in journal lines. 

    Is there an easy way to find Display value from Description ?

  • Suggested answer
    Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    Hi VDY.

    a few things to note. Descriptions are not guaranteed to be unique. You could have a cost center and department with the same name, or even two cost centers with the same name, so a direct link from Description to display value will not work.

    You can look at the table: DimensionFinancialTag for custom dimension values (non backing entity types).

    But I would recommend you work through the framework classes similar to the way DIXF works to find and create default dimension sets. Do not try and create these yourself, or try to lookups yourself.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans