All you issues are related to exporting dynamic members. When this option is enabled, Essbase needs to calculate dynamic block in memory before exporting. Based on your database configuration and number of dynamic calc members (mostly should be in dense dimensions), essays needs to decompress dynamic block in memory. Unfortunately, there are very few optimizations that you could do to dynamic calc members or dynamic calc memory, which in turn has an upper limit.
Is there a way to export data without exporting dynamic calc members? That would be the only sure shot way to making this run faster. Just to give you an example: I did the same in once instance where export took more than 3 days and by reducing/removing dynamic calcs brought it down to less than 30 minutes.
FIX("Rest of Year Forecast")
FIX("Number of Other Net New Hire Colleagues")
what i have noticed sometimes is that when you export the file in column format the time will be consumed more as compared to the default one.
since you are only facing the problem with dynamic calc members you can try to work around the dynamic calculator cache
go through the link and all the related commands along with dynamic calc cache and see if there is any improvement