In Oracle Warehouse Builder version 11g, Oracle BI Enterprise Edition features

• Derive metadata from data models in OWB
• Create in OBI EE:
  • Physical Tables
  • Logical Tables
  • Dimensions and Hierarchies
• OWB generates repository file for BI EE
• Provides end-to-end attribute level lineage and impact

Reference : Jean-Pierre Dijcks Presentation