Dimensional Models Dedicated full featured Dimensional model – star and snowflake schema easily can be built and expressed on detailed and compact diagrams Dimensions – support for merging (level can belongs to more than one dimension), shared, fact and role playing dimensions Hierarchies – value based hierarchies (parent-child), and regular and ragged level based hierarchies Measures – fully, semi and none additive; different aggregation functions on different dimensions ; fact dimension; calculated measures Query wizard allows Select statements to be generated from the dimensional model Support for Oracle OLAP. This includes specifics like cube partitioning, sparse dimensions, and compressed measures Built-in wizards help to define all required object types and view definitions that enable SQL access to dimensional data in Oracle AW (using the OLAP_TABLE interface) Bidirectional integration with Oracle physical model - Dimensional model can be created using SQL dimension definitions in physical model or the definitions can be created from the dimensional model