Chapter 9 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 about relational to multidimensional mapping, see the "Relational to multidimensional mapping" section in the "Using Mappings" chapter in the General Features Guide ".
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) 2007. Sybase Inc. All rights reserved. |
| |