FCCS: Movement dimension with Dynamic Calc on Member Formula is slow to refresh
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?