Selection

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."