Why use dimension hierarchies?
As the building blocks of cubes, dimension hierarchies are the basis for a variety of reports that can be used for data exploration, quick counts, or as a basis for targeting campaigns. Cubes can pre-aggregate counts or simple calculations (sum, min, max, mean, standard deviation) of numeric fields (for example, total sales across all products at increasing aggregation levels, cross-tabular analysis of expenses versus sales by geography, and so forth).
Dimension hierarchies are also available as a means of selecting directly from strategic segments (without requiring any cubes to be built or to work from a cross-tab report).
Campaign
supports:
Dimensions that are comprised of an unlimited number of levels and elements
Data points built as input to customer analytic reporting and visual selection
Rollups into unlimited number of categories to support drill-down capability
Copyright IBM Corporation 2015. All Rights Reserved.