Allocation to Siblings

Summary: Hello, we have an allocation requirement where source data will come against children member in hierarchy, and it needs to be allocated to the siblings of Source member including Source member i.e. children under same parent. Allocation Dimension contains 20000 members.

Example: Dimension Hierarchy

Product - X1 (Parent)

S1 - Child

S2 - Child

S3 - Child

Source Data at S1 needs to be allocated to S1, S2, S3 based on Gross Sales.

X2 (Parent)
A1 - Child

A2 - Child

A3 - Child

Source Data at A1 needs to be allocated to A1, A2, A3 based on Gross Sales.