What is the percent consolidation on the Entity within the Stat hierarchy? You could use the Org-By-Period Elimination if you are utilizing Percent Consolidation between the hierarchies. Here is an explanation from the Foundation Handbook:
The Org-By-Period Elimination Consolidation Algorithm Type uses the calc-on-the-fly Share – as in Standard – but has unique elimination considerations. When determining if the data cell’s IC Member is a descendant of the Entity being consolidated, this Consolidation Algorithm Type considers the position of the Entity in the hierarchy and also checks the Percent Consolidation for every relationship down the hierarchy. If Percent Consolidation is zero for the particular relationship, the IC Member is determined not to be a descendant of the Entity.
In comparison, the standard elimination (hierarchy elimination) only considers the position of the Member in the Entity Dimension hierarchy. Standard elimination is the default approach and does not consider Percent Consolidation.
