Group items tagged

A cube can be considered a generalization of a three-dimensional spreadsheet.

Each cell of the cube holds a number that represents some measure of the business

OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system.

The logical data model includes the following entities: ■ Reference Entities ■ Lookup Entities ■ Base Entities ■ Derived Entities ■ Aggregate Entities

Data in the base entities support the derived and aggregate layers to facilitate Star and population, and act as a source for Data Mining for advanced analysis.

racle SQL Developer Data Modeler provides a model driven approach for database design and generation, implemented by integrated set of models – Logical, Data types, Dimensional, Relational, Data Flow diagrams and Physical models for supported Oracle Databases, Microsoft SQL Server 2000 and 2005

Cube Views metadata

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