Using Shadow Parent Members in Hierarchy Allocation
ASO databases do not allow storing data at the parent member level, so for each hierarchy branch where a value for the entire branch is desired, you can create a level 0 "shadow" parent member.
Consider the following customer hierarchy:
In this hierarchy, the "shadow" Parent members are:
- All Department Stores
- All Specialty Retailers
- All B&B Bikes