Chapter 6 Working with PDMs
Cubes in an OLAP database have to be filled with data from a data warehouse, data mart or operational database.
You use text files to load data in the cubes of the OLAP database. The text files contain records and fields. A record is a row of fields that is read as a unit, and a field is a vertical list of values.
In the multidimensional diagram, each cube is associated with a query. There is actually one cube per mapping and per data source. The query defined on a cube is used to extract data from a data warehouse or operational database to populate the cubes in the OLAP database. The link between the data warehouse database and the OLAP database is a relational to multidimensional mapping.
For more information on relational to multidimensional mapping, see section Defining a relational to multidimensional mapping.
The Generate Cube Data feature allows the generation of a text file containing the cube data. This text file will then be loaded to populate the cubes in the OLAP engine.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |