So, we spent some time one afternoon trying to figure out some sort of common thread with the disappearing dimensions. It seemed like different combinations of dimensions would cause the issue. After talking with Microsoft, it was determined that the issue is a 512 character limitation on the dimension field in the tree. So, when you add multiple dimensions to a tree branch/unit, it may add up to 512 pretty quickly since MR includes the dimension name for each dimension you include.
I know that this may be working as designed, but this seems like something that many users would encounter over time-- particularly those with large/long account strings.
As a workaround, I suggested that the client used dimension sets on the branches of the tree instead. And this worked great, except that there also appears to be a size limitation on the dimension set as well. So if the user tries to add too many dimension combinations (apparently also variable based on the dimension name and other characters included in the string) it also causes a series of errors. In this client's case, they would get one of the following errors:
- Object is currently in use elsewhere
- Column ‘ParentAccountSetID, LinkIndex’ is constrained to be unique. Value ‘8e1f4448-f5c1-461a-b898-f7c7cc572bf2,23’ is already present
I know that both of these issues may seem to minor for a lot of clients. But as I have recently been working on MR reports for a Dynamics AX client with a large account string and long chart of accounts, I do worry that we might start to hit up against these sort of issues more frequently. The workarounds that seem to be available for now include:
- Keeping dimension sets small
- Using dimension sets instead of including large lists of dimensions on a tree
- Using ranges and/or wildcards wherever possible to decrease the number of characters used
- Use shorter names for your segments, so that they take up less space when repeated in a dimension list
Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional. She is a supervising consultant with BKD Technologies, providing training, support, and project management services to new and existing Microsoft Dynamics customers. This blog represents her views only, not those of her employer.