I need to delete all current dimensions and also clear all dimension info in related tables, eg. LedgerTrans, CustTrans, VendTrans etc.
In standard Ax this can probably not be done due to restrictions in the DeleteActions of the Dimension table, closed fiscal years etc., but I really need to get rid of all dimensions due to a new setup. Any pointers as to how to achieve this ? Should I, a) create a Class that would "merge" existing dimensions into a "dummy" dimension, eg. a blank dimension ID ? b) create a Job that would run through related tables and clear the dimension fields - using doUpdate ? c) do nothing in Ax, but instead do the cleaning up directly in the SQL database ? d) do something completely different ? e) forget about it - it cannot be done ... ? Thanks in advance ... Best Regards /Jens