Alternate Hierarchies

An alternate hierarchy may be modeled in either of the following ways:

Table 198. Example Hierarchies and Alternate Hierarchies for the Product Dimension of ASOsamp.Sample

Product

Hierarchy

Alternate Hierarchy (containing shared members)

Flat Panel

Products, All Merchandise, Personal Electronics, Home Entertainment, Televisions

Products, High End Merchandise

HDTV

Products, All Merchandise, Personal Electronics, Home Entertainment, Televisions

Products, High End Merchandise

Figure 156. Aggregate Storage Outline Displaying the Alternate Hierarchy High End Merchandise on the Product Dimension

This image shows an outline in which the Products dimension includes the High End Merchandise alternate hierarchy.

The following restrictions apply when creating alternate hierarchies in aggregate storage outlines:

Note:

In an aggregate storage database, a shared member automatically shares any attributes that are associated with its nonshared member. This also applies to an implied shared member (for example, a member that has only one child). See Understanding Implied Sharing. You can prevent implied sharing by setting the Never Share property; see Determining How Members Store Data Values. This behavior of shared members and attributes in aggregate storage databases is different from the behavior in block storage databases.