The dimension exists as a default dimension. You cannot delete the dimension.
While trying to delete a new financial dimension I’d created, Ireceived the following error: The dimension exists as a default dimension. You cannot delete the dimension.
The dependent records I needed to delete were in two tables: DimensionAttributeSetItem and DimensionAttribute. (Make sure to update your URL strings appropriately)
For more information, see my previous post for more information on deleting records from tables and the Table Browser Caller Chrome Extension
About the Author
Josh Knox is a Functional Consultant for SAGlobal, where he helps provide strategic consulting services around the design and deployment of the client’s Dynamics ERP system. Josh identifies client requirements, assists with system setups and configurations, writes development specifications, provides training, and performs other project activities. He has significant experience helping professional services companies with their Dynamics 365 implementations, particularly in the areas of data migration, workflow design, business intelligence, and Projects+ – SAGlobal’s custom enhancements to the Projects module.