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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Dimension doesn't ...
Microsoft Dynamics AX (Archived)

Dimension doesn't contain all fields of a unique index

(0) ShareShare
ReportReport
Posted on by Community Member

i've created a  cube and it went well till i tried to add new field to the query after i added it it gives me this warning while processing the cube "The object \\Data Dictionary\Views\Retail does not contain all of the fields that are required to build a unique index. The resulting dimension may cause duplicate key processing errors. To avoid the errors, make sure that a perspective includes all required fields." and when i try to browse the cube I don't find the new field. What should i do?

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,693 Most Valuable Professional on at
    RE: Dimension doesn't contain all fields of a unique index

    Hi, I've changed the title because the original one, "Dynamics AX 2012", didn't say anything about the problem.

    The error message suggest that you miss some fields necessary for unique identification of a dimension, therefore focus on that. I can't be more specific, because I don't have any details about what you did.

  • Community Member Profile Picture
    Community Member on at
    RE: Dimension doesn't contain all fields of a unique index

    I did add all the necessary fields but nothing is showed after processing the cube

  • Martin Dráb Profile Picture
    Martin Dráb 237,693 Most Valuable Professional on at
    RE: Dimension doesn't contain all fields of a unique index

    Does it mean that you've managed to get rid of the error and now you have different problem?

    Please don't forget that we depend on information from you. We can't help you if you don't give us enough details.

  • Community Member Profile Picture
    Community Member on at
    RE: Dimension doesn't contain all fields of a unique index

    yes any new update I do didn't show after processing the cube

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
Priya_K Profile Picture

Priya_K 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans