re-usable calculation manager member block script component
I have a situation where I have 2 dense dims (account and period). I have business rule that needs to calculate every account but in order to squeeze the most performance I need to repeat my calc member block 12 times (1 for each member). a time period member block keeps means dense calculations which is good.
My question is: has anyone come up with a way to introduce ta re-usable component in a business rule that would allow me to write the calc member block once then dynamically loop the calc block member? Just trying to avoid having to copy and paste 12 times. introducing another dense dim (even single member dense) is not an option