Selection Steps in Workbooks
In Oracle Analytics, you can use selection steps to specify which levels or members of a hierarchy you want to display in table or pivot table visualizations that use that hierarchy.
Selection steps are similar to filters, but instead of filtering to select values from a column, they let you select members of a hierarchy to participate in the query. You can choose which levels or members of the hierarchy you want to keep, add, or remove in your selection. You can add as many selection steps as you need, and they're applied in a specific order.
Hierarchies
Oracle Analytics supports using selection steps for both level-based hierarchies and parent-child hierarchies, including those with skip-level or ragged structures.
Level-based hierarchies (structure hierarchies) - In these hierarchies, members of the same type occur only at a single level, while members in parent-child hierarchies all have the same type. In level-based hierarchies, levels roll up from a lower level to higher level, for example, months can roll up into a year. These roll ups occur over the hierarchy elements and span natural business relationships.
Parent-child hierarchies (value hierarchies) - In these hierarchies, the business relationships occur between different members of the same real-world type such as the manager-employee relationship in an organizational hierarchy tree. Parent-child hierarchies don't have explicitly named levels. There isn't a limit to the number of implicit levels in a parent-child hierarchy.