FCCS: Movement dimension with Dynamic Calc on Member Formula is slow to refresh

Content

Hi all

From Oracle suggestions: https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/agfcc/working_with_member_formulas_sui.html

It is not recommended to use NOT  member formula for a movement member. However we need it to get the desired results for the attached formula. However it is VERY slow to refresh in Smartview. 

if we use Store, we do not get the performance issue, but it does not render the correct calculation. 

Can someone please let me know what are the alternatives to using Dynamic Calc in member Formula - for Movement members?

Thank you 

NOuria