So far we've covered cases when there is a need to isolate a single member in the hierarchy, be it a root member or any other member in the hierarchy. This recipe deals with detecting whether the ascendants or descendants of the current member are on a particular cascade or branch in that hierarchy.
Let's illustrate this with a few examples.
Suppose we want to analyze dates. There's a concept of the current date, but since that date is usually found in a multilevel user hierarchy, we can also talk about the current month, current quarter, current year, and so forth.
Another example is the regional customer hierarchy. There we can detect whether a particular customer is living in a particular city, or if that ...