Analyzing Alternate Hierarchies

You can create crosstabs that show two different hierarchies of the same dimension in the rows and columns. Do this to isolate and analyze relative data at a fine level of granularity.

For example, you create a report that includes information on retailer types. The Retailers dimension in your report includes categories for each type of retailer, and an alternate hierarchy category that represents the vendors by region. Individual retailers are the lowest level in the Retailers dimension. In the alternate hierarchy, individual vendors are also the lowest level. When you create a crosstab that has the alternate hierarchy by retailer site in the rows and retailer type in the columns, you can quickly analyze the relative performance of the retailer type in the different regions.