Chapter 4 Building Multidimensional Diagrams
A cube is a collection of measures corresponding to values stored into each of its data cell. The measures are organized into dimensions to provide for faster retrieval and drill-down.
Usually a cube is associated with a fact that allows to define and share measures among cubes.
For more information on facts, see section Defining facts in a multidimensional diagram.
In a multidimensional diagram, the cube represents an OLAP cube. Cubes need to be created and populated via a text file in the OLAP engine. This text file contains a query used to extract data from a data warehouse or operational database to fill the cubes in the OLAP engine. You define this query from the Query page of the cube in the multidimensional diagram.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |