Forum Stats

  • 3,875,763 Users
  • 2,266,969 Discussions


Oracle Discoverer Drill

3004 Member Posts: 204,171 Green Ribbon
How to create a drill that traverses a customer hierarchy which has infinite levels;
The database model is a star schema, for a data warehouse project; the customer dimension table is joined to a fact table, and we need a drill-down report, starting from the customer at the top of the hierarchy ; we tried many different ways of designing customer table to support this drill down, nothing seems to work...

Any thoughts on this?

Thanks, Raquel


  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    Consider using a CONNECT BY clause in your SQL. You could do this in Discoverer by creating a Custom folder or at the database level in a VIEW definition.

    Oracle DIscoverer Team
This discussion has been closed.