Preparing Trees and Queries

After defining goals, you must design the PeopleSoft trees and queries that are appropriate for creating both the structure and data of the Essbase cube that you plan to build.

You define queries to extract the data from the PeopleSoft database and load it to the cube.

General Ledger delivers sample queries and trees that you can use to design your own that adequately define the parameters for loading desired data to the Essbase cube:

Field or Control	Description
General Ledger Queries	OLAP_ACCOUNT_FLIPSIGN OLAP_ACCTREE_FLIPSIGN
General Ledger Trees	ACCTROLLUP PRODUCT DEPARTMENTS ACCOUNTING PERIOD

Field or Control

Description

General Ledger Queries

OLAP_ACCOUNT_FLIPSIGN

OLAP_ACCTREE_FLIPSIGN

General Ledger Trees

ACCTROLLUP

PRODUCT

DEPARTMENTS

ACCOUNTING PERIOD

Note: For an incremental load, the queries must be based upon the GL_ESS_QRY_VW view to ensure that the ledger rows are selected correctly. Use the query, GL_ESS_LOAD_LEDGER, as a starting point and adjust or update it according to your specific requirements.