Hyperion Planning : Grid Spread and Locking Cells

Hi,

I am facing a problem. I have a large sparse dimension and all their members are stored. I locked a parent member but when I do a grid spread in a parent of that locked member the children that are under that locked parent are modified. I know that in order to not change their values their parent should be dynamic calc, but turning all the hierarchy dynamic calc will cause performance issues.

Is there any workaround that we could proceed? Is there a way to lock the parent member and automatically lock its children?

I appreciate any response,