Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for Oracle 11i >

Configuring the General Ledger Account Hierarchies


This task is a step in the Process of Configuring Siebel Financial Analytics for Oracle 11i.

The Siebel Customer-Centric Enterprise Warehouse prepackages a hierarchy table (IA_HIERARCHIES) to store hierarchy information. The Siebel General Ledger Analytics application uses this table to store Siebel General Ledger Analytics account hierarchy information.

General Ledger accounts are loaded as part of the Finance workflow.

To configure the General Ledger hierarchical information

  1. Load the General Ledger Accounts data into the IA_GL_ACCOUNTS table.
  2. Load all hierarchies that are configured in your source system into the IA_HIERARCHIES table.
  3. Configure mappings and sessions to update the following hierarchy columns in the IA_GL_ACCOUNTS table—HIER1_KEY, HIER2_KEY, HIER3_KEY, HIER4_KEY, HIER5_KEY, and HIER6_KEY.
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide