Understanding How to Plan the OLAP Database

Integrating OLAP tools with General Ledger data begins with a careful examination of the data that you want to report on and analyze by using OLAP. You must define specific goals and determine the results that you need from online data analysis.

The following describes the process flow when building Essbase cubes using PeopleTools Cube Builder:

• Load initial and incremental cube metadata using trees and dimension queries.

• Load incremental transaction data, adding appropriate criteria (date time stamp) in the query.

See Preparing Trees and Queries.

See also, PeopleTools PeopleBook: Designing Cube Metadata