a logical set of data that is organized and structured in a hierarchical, multidimensional arrangement. A cube is a directory structure, not a single file. A cube can include measures, and it can have numerous dimensions and levels of data.
An extraction from a database that provides dimensions (data structure) and facts (data content) for use in business analysis.
a collection of dimensions and measures in a particular subject area
a database of de-normalized tables
a fact table that is linked to a subset of dimensions that are available in the database at a given grain
a logical organization of multidimensional data
a multidimensional framework to which you can assign measures
a multidimensional representation of business facts that can be accessed quickly to provide specific information
a multidimensional structure that contains dimensions and measures
an object with three dimensions
an OLAP metadata entity
a representation of multidimensional database data in a dimensional model
a set of dimensions that provide organizational structure for measures
a special data structure populated with data from your database
a specialized database that is optimized to combine, process, and summarize large amounts of data in order to provide answers to questions about that data in the shortest amount of time
a three-dimensional object made up of two-dimensional objects, all at right angles
Also known as multidimensional cube or PowerPlay cube. It is a .mdc file created by Cognos PowerPlay Transformer. It contains measures (data) organized into dimensions to allow various views of a database. All PowerPlay view files (.ppr) point to a defined view in a cube file.
A multidimensional structure that forms that basis for OLAP applications. Despite the name, most OLAP cubes have many more than three dimensions. in multidimensional OLAP (or MOLAP) databases, cubes are created and stored physically, whereas in relational OLAPs, cubes are a virtual concept based on a star or snowflake schema. A variety of corss-dimensional calculations and aggregations are possible within a cube, and the dimensions can usually be pivoted in reports.
A multidimensional database. A multidimensional database is a method of referencing data through multiple dimensions. An individual cell is the intersection of a point for a set of dimensions.
The basic structure of data in a data warehouse, analogous to a record in a relational database. A data cube contains dimensions, hierarchies, levels, and members. Each specific data location in a cube is called a cell.
A structure in which data is arranged along various dimensions (for example, time, geography, and product line), and is used to support OLAP functions.
A data cube is a multidimensional structure that contains an aggregate value at each point, i.e., the result of applying an aggregate function to an underlying relation. Data cubes are used to implement online analytical processing (OLAP).
A multidimensional data source created in PowerPlay Transformer. It contains measures (data) organized into dimensions to provide faster retrieval and drill-down in PowerPlay.
A set of data that is organised and summarised into a multidimensional structure defined by a set of dimensions and measures.
A three-dimensional "view" of data with a dimension forming each side of the cube. Typical dimensions for a human resources cube are time, jobs, and components.
The fundamental structure for information in an OLAP system. A structure that stores multi-dimensional information, having one CELL for each possible combination of dimensions.
One of the Oracle8 operators that can be used in a GROUP BY clause for dimensional analysis. Similar to the ROLLUP operator (see ROLLUP), but also includes cross-tabulations--i.e., it uses every possible combination of the columns or expressions in the GROUP BY clause to produce super-aggregate rows.
A logical organization of measures with identical dimensions. The edges of the cube contain dimension members and the body of the cube contains data values. For example, sales data can be organized into a cube, whose edges contain values from the time, product, and customer dimensions and whose body contains Volume Sales and Dollar Sales data. In a star schema, a cube is represented by a fact table.
See Data Cube.
A set of data generated by OLAP that is organized into a multidimensional structure that contains dimension and summary data.