Bookshelf Home | Contents | Index | PDF     

Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics >

About PeopleSoft Trees in Siebel Financial Analytics

For PeopleSoft, the Siebel Financial Analytics application sources data from a data structure, called PeopleSoft Trees, to get information about the organization's General Ledger hierarchies, Profit hierarchies, Cost Centers' hierarchies, and so on.

PeopleSoft Trees are a flexible, generic way of constructing hierarchical summarization of a particular database fields in PeopleSoft for reporting purposes. Typically, entities such as Chart of Account fields (Account, Dept, and Project, and so on), items, locations, and so on, are organized into user-defined trees.

Table 68 lists the PeopeSoft Trees the Siebel Financial Analytics application sources.

Table 68. PeopeSoft Trees for Siebel Financial Analytics
PeopleSoft Data Structure
Repository Source Name
Description

PeopleSoft Tree

ACCTROLLUP

Account Rollup

PeopleSoft Tree

AR_BUSINESS_UNITS

AR Business Unit Roll-Up

PeopleSoft Tree

DEPARTMENTS

Manufacturing Departments

PeopleSoft Tree

OPERUNIT

Operating Unit

Table 69 lists the mappings and sessions using PeopleSoft Trees.

Table 69. List of Mappings And Sessions Using PeopleSoft Trees
Repository Source Name
Mapping
Session

ACCTROLLUP

M_P_GL_ACCTS_HIERARCHY_EXTRACT

S_M_P_GL_ACCTS_HIERARCHY_EXTRACT

AR_BUSINESS_UNITS

M_P_BUSN_ORGS_COMPANY_HIERARCHY_EXTRACT

S_M_P_BUSN_ORGS_COMPANY_HIERARCHY_EXTRACT

DEPARTMENTS

M_P_PROFIT_CNTRS_HIERARCHY_EXTRACT

S_M_P_PROFIT_CNTRS_HIERARCHY_EXTRACT

OPERUNIT

M_P_COST_CENTERS_HIERARCHY_EXTRACT

S_M_P_COST_CENTERS_HIERARCHY_EXTRACT
    
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide