Populating Local Cubes with Data

Concepts for populating local cubes are described in Populating Local Cubes. This topic and its subtopics describe the code required to perform this task.

Populating local cubes with data is accomplished in three steps:

1. Listing Cube Elements. This step includes the INSERT INTO statement without its SELECT clause.
2. Populating the Dimensions Structure. This step includes the SELECT clause of the INSERT INTO statement.
3. Populating Cube Data. This step reads the data source and creates the local cube file.