Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
One night, I was trying to mass update default dimensions for certain accounts via the Legal entity overrides a while back and ran into something that took me forever to figure out and gave me a headache from banging my head into the wall. No matter how I changed the order, the dimension structure looked exactly the way it did when I started!
I was using DIXF and exporting the Financial dimension value legal entity overrides entity. After making the changes I needed, I imported the file back in using the same entity. Pretty cut and dry stuff.
To do this, I needed to make sure I had the dimensions in the order that I wanted and had all the dimensions included I needed. To do so, I went to the General ledgerChart of accountsDimensionsFinancial dimension configuration for integrating applications and adjusted the values in the Default dimension format.
Financial dimensions for integrating applications
After these changes, I exported the file again, and to my dismay, realized that my changes didn’t take. The dimensions in the FixedDimensionDisplayValue were in the same order that they were when I started. This led me down a path trying to figure out what the heck happened.
I deleted and recreated all the dimension formats, tried moving dimensions around, removing some of them, adding in the main account – anything I could think of. As it was late in the night, my next step was debugging what was going on.
Finally, I got to the bottom of it. For performance reasons, the expansion of the default dimension format into a list of ordered dimensions is completed once and then cached in the AOS. No matter the changes I made, the cache wasn’t being flushed and they weren’t being looked at.
How to fix it? Restart the AOS. Should have thought of that earlier…
As pointed out by some folks on Twitter, a cleaner and quicker way to resolve this issue is to flush the data cache using the class runner. To do this, in your browser, type in https://[your_D365_URL]/?cmp=DAT&mi=SysClassRunner&cls=SysFlushData. This ought to do it and save you the trouble of a restart.
The post Default dimension formats cached? Why!? appeared first on Dynamic Consulting.
Business Applications communities