Dimension doesn't contain all fields of a unique index

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Dimension doesn't contain all fields of a unique index

yes any new update I do didn't show after processing the cube
Martin Dráb 229,918 Most Valuable Professional on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 229,918 Most Valuable Professional on at

Like (0)

Report

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.