Forum Stats

  • 3,853,655 Users
  • 2,264,249 Discussions
  • 7,905,426 Comments

Discussions

Oracle Discoverer Drill

3004
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

Comments

  • 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.

    Regards,
    Oracle DIscoverer Team
    http:\\technet.oracle.com
This discussion has been closed.