You can design a multichain hierarchy that builds dimensions with shared members, also known as alternate hierarchies.
One way to accomplish this is to create a copy of the dimension element that you want to designate as a shared member. By making a copy, the binding expression for this element is the same as the original dimension element. In Figure 8, Multichain hierarchy with shared member (alternate hierarchy), this is the SKU_Diet. Then, when you create the second hierarchy in the chain, which is the alternate hierarchy, add a user-defined member as the parent and add the new dimension element (SKU_Diet) as the child, which will be the shared member, as shown in Figure 8, Multichain hierarchy with shared member (alternate hierarchy).
