Many questions in Microsoft forum about this topic: “How to generate new dimension ID from data (dimensions...
Roberto Stefanetti Business Central Blog
MCT & MVP in Microsoft Business Applications