View-Concept Data Mining Oracle

[beyond]

i need for our data-warehouse-project a concept for generating views:

i want to prepare the relational database-structure (physical) for a
reporting tool webfocus by generating suitable views (joins,
dimensions)

does anyone has a collection of technical rules/principles (sql) for
this?