Knowledge Prospector lets you create your own dimension hierarchy without
having to change the actual cube. Your custom hierarchy can contain folders, other
hierarchies, sublevels, individual items, custom time periods, and rule-based selections.
In our example, we've created a Thanksgiving folder containing the existing
hierarchies of "Food" and "Drink" as well as our own custom members of
"Top 25% of Baking Goods" and "Beverages with Unit Sales Greater Than Sales
Average."
|