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:

Customer hierarchy showing All Department Stores, All Speciality Retailers, and All BB Bikes as shadow parents

In this hierarchy, the "shadow" Parent members are:

  • All Department Stores
  • All Specialty Retailers
  • All B&B Bikes