Our drill paths are based on the universe structure.

Usually, the universe designer defines drill hierarchies that can be used for analysis according to the business user's requirements.

These hierarchies can either be ordered by the object order in the universe folders or by a custom order that can create a structure of objects oriented from different classes in the universe; for example, a costume drill hierarchy can be to switch from the product category to the customer ID. In a more traditional hierarchy, we will explore the items that belong to that product category, such as the category, subcategory, and product name.

We already learned about the basic drill mode and the scope of analysis in Chapter 2, Creating New Queries, so we will be adjusting our drill mode into a custom drill mode in order to expand the use of the universe hierarchy structure.

Classical hierarchies are the time, geographical, and organizational structures; they are demonstrated in the...