|Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)
Part Number B32519-02
Use this dialog to select the type of hierarchy that you want to create. For example, to select a date hierarchy when you want Discoverer end users to be able to drill into time-based data.
For more information, see:
Which type of hierarchy do you want to create?
Use this option to select the item hierarchy type.
Use this option to select the date hierarchy type.
The hierarchical relationships that you create are not defined in the database, but in the business area.
Item hierarchies are used to connect multiple items in a specified order, allowing your user to drill up and down to different levels of detailed information. For example, you can connect the columns country, region, district, and retail store to create a location-based sales hierarchy. Each higher item (country is higher than region, for example) being a super-set of the items below it. When you create this sales hierarchy, users can create a worksheet that displays sales by country, then drill down to get regional details for each country, and so on down to the retail store level.
A date hierarchy lets your users drill up or down into date items from virtually any time-based perspective. For example, users can see sales data based on year, then drill down to quarter, and even further to month. Date hierarchies, unlike Item hierarchies, possess an inherent structure based on year, quarter, month, week, day, hour, minute, and second. Therefore, Discoverer Administrator uses pre-existing Date Templates to define many common formats for date hierarchies. In addition, you can create customized date hierarchies.